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

Reply via email to