[PHP] Re: Recursive Select Box

2004-02-19 Thread Justin Patrin
PEAR DB is just a pckage which allows you to connect to any DB with the same interface, it will work with mysql. http://pear.php.net/package/DB If you don't want to use that, just switch the calls to mysql ones: function getSelect(&$link, $catParent = 0, $indent = '') { $sth = mysql_query('SE

[PHP] Re: Recursive Select Box

2004-02-18 Thread Matt Palermo
No, i'm using a MySQL DB. "Justin Patrin" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Matt Palermo wrote: > > > Hey everyone. I'm looking for assistance/suggestions/answers on how to > > build a select dropdown box from data that needs to be pulled recursively > > from a MySQL d

[PHP] Re: Recursive Select Box

2004-02-18 Thread Justin Patrin
Matt Palermo wrote: Hey everyone. I'm looking for assistance/suggestions/answers on how to build a select dropdown box from data that needs to be pulled recursively from a MySQL database. Basically the situation is mainly for a dicussion thread system type of thing where I have categories nested

[PHP] Re: Recursive Select Box

2004-02-18 Thread Jakes
use two loops 9(or as many as you need) with global varaibles. If a variable in the top level loop is executed it prints out the second loop. You need to do round trips to the db. "Matt Palermo" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hey everyone. I'm looking for assistance