Thank you Stuart!! I feel like an idiot... I had tried moving one or
the other outside the loop, but not both... Thank you again!!
Chase
Stuart Dallas wrote:
> On Saturday, June 29, 2002 at 10:03:16 PM, Chase wrote:
>
>>I am *very* new to PHP, so this may seem like a stupid question... I am
>>trying to generate dynamic drop-down lists for use in an HTML form, but
>>I have done something wrong with my code. Instead of getting one list
>>box with three options, I am getting three list boxes with one option.
>>I have included this piece of my code... Can anyone help???
>>
>
> Yes, you have the select open and close tags inside the loop. Move them either
> side as follows...
>
> <?
> $link = mysql_connect("localhost", "user", "pass");
> mysql_select_db("my_db", $link);
>
> $result = mysql_query("SELECT SKU, Description, Retail FROM linecard
> WHERE sku=61 or sku=239 or sku=318", $link);
> $num_rows = mysql_num_rows($result);
>
> if($num_rows) {
> print("<select name=\"test\">");
> while($row = mysql_fetch_row($result))
>
> {
> print("<option value=\"$row[0]-$row[1]-$row[2]\">$row[1] -
> \$$row[2]</option><br>");
>
> }
> print("</select>");
>
> } else {
> print("<option value=\"\">No Parts Created Yet</option>");
> }
> ?>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
