also, to get existing vals to show in the select as default,

<select name="colorz">
while($row=mysql_fetch_array($result)){
$selected=($row["ID"]==$ID)?"selected":"";
echo "<option value='" . $row["ID"] . "' $selected>" . $row["name"] .
"</option>\n";
}
</select>
the value can be in single quotes also, altho i dont think quotes matter
unless you use opera or some other wierdass browser (you can also put
doubles using \")
I believe (correct me if im wrong) that since echo is a construct and not a
predefined function, it runs faster.





"Matt Stewart" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> yep, that's basically what i use for this sort of thing - it's a nice
short
> simple function, and works a treat. Obviously if you'd rather be passing
the
> actual colour name to the next step, you use printf("<option
> value=%s>%s</option>", $myrow["colorname"], $myrow["colorname"]);
> I also prefer to use printf("<option value=\"%s\"> so it has the value in
> quotes - just a fussy html thing i do though.
>
> -----Original Message-----
> From: Matthew Crouch [mailto:[EMAIL PROTECTED]]
> Sent: 13 December 2001 22:58
> To: [EMAIL PROTECTED]
> 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 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]
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.306 / Virus Database: 166 - Release Date: 04/12/01
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.306 / Virus Database: 166 - Release Date: 04/12/01
>



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