or alternatively, you can download a drop down box populating class from

http://phpclasses.upperdesign.com/


----- Original Message -----
From: "Matthew Crouch" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 14, 2001 6:57 AM
Subject: [PHP-DB] Re: Dynamically populating a dropdown box


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


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