[PHP-DB] Re: MySQL/PHP Iterative Tree

ique ID. This is a fundamental basis of all my systems. - -- See you in Cyber space, ___ David |David Elliott| Software Engineer| _| [EMAIL PROTECTED] | PGP Key ID 0x650F4534 | | W

[PHP-DB] Re: MySQL/PHP Iterative Tree

trees, however it does have some limitations. (1) Adding another tree / series of nodes into the middle if the set. (2) A child node that belongs to more than one parent. - -- Cheers, ___ David | David E

[PHP-DB] Re: MySQL/PHP Iterative Tree

hat would be nice is to do it dynamically and display only the tree that you need and just get the data for the children when needed. eg like MSDSon M$ site - -- TTFN, ___ David |David Elliott| Software En

[PHP-DB] Re: regarding multiple joins

order by f.name == One I made earlier = HTH - -- Best regards, _______ David |David Elliott| Software Engineer| _| [EMAIL PROTECTED] | PGP Key ID 0x650F4534 | | "It shou

[PHP-DB] Re: Get Last ID Inserted

rrent scope. ==8<= - -- Ti2GO,___ David |David Elliott| Software Engineer| _| [EMAIL PROTECTED] |

[PHP-DB] Re: Get Last ID Inserted

es (@NewId,37,19,45,134,70,70) Update country set DelId = @NewId where itemid = 288 commit select @NewId NewDelId ==8<= - -- Ti2GO,___________ David

[PHP-DB] Re: Get Last ID Inserted

sed on > the same criteria of your insert (which might be overlapping)? select @@identity - -- Cheers, ___ David | David Elliott| Software Engineer| _| [EMAIL PROTECTED] | P