> 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";
mysql_fetch_assoc (http://www.php.net/manual/en/function.mysql-fetch-assoc.php) and mysql_fetch_row (http://www.php.net/manual/en/function.mysql-fetch-row.php) both return a row. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php