I am querying a database to populate a list. The list is suppose to start
with the first line of information in the database and continue untill have
been displayed.

The problem I am having is the first line in the database is not being
displayed. The display starts on the second line.

Here are the MySQL commands to retrieve the data...

 $fSelect = "SELECT lot,size,price FROM properties WHERE status =
'Available' ORDER BY lot ASC";
 $fSql = mysql_query($fSelect, $db) or DIE("Unable to retrieve data");
$useFields = mysql_fetch_array($fSql, MYSQL_ASSOC);

The next line prints the lot field to the screen. The number printed to the
screen is the second lot number that matches this database query.

Any suggestions on how to get the first information displayed to the screen?


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

Reply via email to