Thanks everyone for the help, I know with other lists, sometimes when you finally get you problem to work you post your answer. Anyway, just in case anyone was wondering, here is what I ended up doing:
<? mysql_connect("localhost","$user","$pass"); mysql_select_db("$db"); $query = "SELECT category_ID,category_name FROM tblCategories"; $result = mysql_query($query); ?> <td>category</td> <td><select size="1" name="category_name"> <? while ($category_array = mysql_fetch_array($result)) { print "<optionvalue=$catergory_array[0].>$category_array[1]</option>"; } ?> </select></td> I had it in a table. anyway thank alot. -chad On Thu, 14 Mar 2002 07:46:36 -0500 chad kellerman <[EMAIL PROTECTED]> wrote: > Hello everyone, > > I am a little new to the list. I have been reading a lot of the posts but have >not submitted yet. But I ran into a problem I was hoping I might get e little help >or at least get a point in the right direction. > > > I have a table called tblCategories with field category_ID with is >auto_incremented and another field called category_name. > > I wish to have a drop down menu on an html page that is generated automatically >with Category_name as the option and the option value=category_ID. It is going in a >form which I submit and adds to a mysql database. Everything is working fine except >I cannot create the drop down menu out of php. I would rather not have to edit my >html page when ever I add a category. > > Is there any place I can look to see how someone else has accomplished this? Or >is there any specific function I should research in the php.net manual pages? I have >been looking but not too successfull. > > thank you for any help you can offer. > > > -chad > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php