Try changing;
my $sth = $db->select( ['ID','Full_Name'] ) || return $GT::SQL::error;
...to;
my $sth = $db->select( ['ID','Full_Name'], { FatherID = '0' } ) || return $GT::SQL::error;
Hope that helps.
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
my $sth = $db->select( ['ID','Full_Name'] ) || return $GT::SQL::error;
...to;
my $sth = $db->select( ['ID','Full_Name'], { FatherID = '0' } ) || return $GT::SQL::error;
Hope that helps.
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!