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
--
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]
