Hi

the row index starts at 0 not 1 so you need $row[0], as you have only one
field $row[1] will be empty.

HTH

Peter

-----------------------------------------------
Excellence in internet and open source software
-----------------------------------------------
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
-----------------------------------------------

> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 12 February 2002 16:10
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Drop Down Menus
>
>
> Hi wonder if anyone knows what I am doing wrong here.
>
> I have a drop down selection menu that is generated from a mysql
> database. In the database we have over 15 fields one of them
> contains text for the catergory that the entry belongs to. I have
> used the following code to generate my drop down menu but when i
> view it in the browser the drop down menu has not listed the
> categories instead we have blank entries for each selection.
>
> <? mysql_connect("localhost","user","password");
>     mysql_select_db("database");
>     $sql = "select distinct category from books ORDER BY category ASC";
>     $makes_result = mysql_query($sql);
>     print ("<select name=\"category\">\n");
>     print("<option selected value=\"\">Please select a
> Category</option>\n");
>     while($row = mysql_fetch_row($makes_result))
>     {
>     print("<option value=\"$row[1]\">$row[1]</option>\n");
>     }
>     print("</select>"); ?>
>
> Thanks for the help.
>
> Barry
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to