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('SELECT * FROM categories WHERE Cat_Parent = '.$catParent, $link);
while($rec = mysql_fetch_assoc($sth)) {
echo '<option value="'.$rec['Cat_ID'].'">'.$indent.$rec['Cat_Name'].'</option>';
getSelect($link, $rec['Cat_ID'], $indent.' ');
}
}
$link = mysql_connect('example.com', 'username', 'password');
echo '<select name="selectBox">';
getSelect($link);
echo '</select>';Matt Palermo wrote:
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 database. Basically the situation is mainly for a
dicussion
thread system type of thing where I have categories nested inside categories, nested inside categories... Anyway, I want to be able to
build
a drop down box containing all the categories indented underneath it's parent category to look something similar to this:
------------------------- Top Level Category - Nested Category - Lower level - Etc.... Top Level Category - Nested Category Top Level Category -------------------------
Then the user will be able to select one from the dropdown menu. I have
all
the categories stored in a MySQL database called site_categories. The
table
is setup like this:
__________________________________ | Cat_ID | Cat_Parent | Cat_Name | |---------------------------------------------| | 1 | 0 | Top Level 1 | |---------------------------------------------| | 2 | 1 | Nested 1 | |---------------------------------------------| | 3 | 0 | Top Level 2 | |---------------------------------------------| | 4 | 2 | Nested 2 | |---------------------------------------------|
Sorry for the bad pictures you hopefully you get the idea. Anything
with a
0 Cat_Parent is a Top Level category. Then the others are all nested
inside
other categories that have the same Cat_ID as the nested categories Cat_Parent. I basically need help creating a properly indented dropdown menu box using this structure from the database. I assume I'm gonna
have to
use some sort of recursion here, but I'm not sure how to go about this. Please help if you can.
Thanks,
Matt http://sweetphp.com
I'd suggest using a recursive function. (I'm assuming you're using PEAR DB...)
function getSelect(&$db, $catParent = 0, $indent = '') { $sth = $db->query('SELECT * FROM categories WHERE Cat_Parent = '.$catParent); while($rec = $sth->fetchRow()) { echo '<option value="'.$rec['Cat_ID'].'">'.$indent.$rec['Cat_Name'].'</option>'; getSelect($db, $rec['Cat_ID'], $indent.' '); } }
$db = DB::connect('mysql://user:[EMAIL PROTECTED]/db'); $db->setFetchMode(DB_FETCHMODE_ASSOC); echo '<select name="selectBox">'; getSelect($db); echo '</select>';
I think that will work ;-)
-- paperCrane <Justin Patrin>
-- -- paperCrane <Justin Patrin>
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
