Re: Dynamically populating a dropdown box
| From: | Matthew Crouch | Date: | Thu, 13 Dec 2001 22:57:48 +0000 |
| Subject: | Re: Dynamically populating a dropdown box | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-15015@lists.php.net to get a copy of this message | ||
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"]);
}
?>
</select>
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