Dropdown list question...
| From: | SBCSI) | Date: | Mon, 29 Jul 2002 16:12:19 +0000 |
| Subject: | Dropdown list question... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-20856@lists.php.net to get a copy of this message | ||
I am populating a dropdown list from a database. This is working
fine with one minor glitch... For some reason, the first entry in the
database does not seem to be getting populated into the list. I do not see
anything wrong, and was hoping that someone else might be able to spot a
problem. Here is the code that generates the dropdown list:
$query_systems = "SELECT Name FROM systems";
$systems = mysql_query($query_systems, $Test) or die(mysql_error());
$row_systems = mysql_fetch_assoc($systems);
$totalRows_systems = mysql_num_rows($systems);
$sys_list = "<select size=\"1\" name=\"system\">\n";
$sys_list .= "<option>System Name</option>\n";
$sys_list .= "<option>-----------</option>\n";
while($name = mysql_fetch_row($systems)) {
$sys_list .= "<option>$name[0]</option>\n";
}
$sys_list .= "</select>\n";
Thanks in advance for the help.
Scott Nipp
Phone: (214) 858-1289
E-mail: sn4265@sbc.com
Web: http:\\ldsa.sbcld.sbc.com