Chad,
Try something like this:
---------------------------------------------
<?
$qry = "SELECT category_id, category_name from tblCategories";
$result = mysql_query($query);
?>
<form method="POST" name="criteria" action="my_postpage.php">
<select name="categories">
<?
while ($category_array = mysql_fetch_array($result))
{
print "<OPTION
value=".category_array["category_id"].">
$category_array[category_name]</OPTION>";
}
?>
</select>
---------------------------------------------
Randy
-----Original Message-----
From: chad kellerman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 14, 2002 6:47 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] creating a drop down menu from mysql categories
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
