I'm no expert, and my code is probably buggy, but I think this is the gist of it:

<select name="color">
$result = mysql_query("SELECT * from colors");
while ($myrow = mysql_fetch_array($result)) {
printf("<option value=%s>%s</option>", $myrow["colorid"], $myrow["colorname"]);

Chris Payne wrote:

> Hi there everyone,
> I have a shopping cart which is starting to work nicely, but I have to select 
>size/color from the entries, how do I do this dynamically in PHP with MySQL?  I need 
>them to be dropdown form boxes but haven't got a clue how to populate them from the 
>fields of my database.
> Please help me with example code if possible, it would be greatly appreciated :-)
> Thank you everyone
> Regards
> Chris

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to