Hi Jef,

This is what i would do: 

$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"); 
for ($i=0;$i<mysql_num_rows($sql_id);$i++)
{
        $useFields = mysql_fetch_assoc($fSql);
        //Your table
        echo "<td>".$useFields['lot']."</td>";
        //The rest of your table
}

I hope this helps

Best regards,
 
Davy Obdam,
mailto:[EMAIL PROTECTED]




-----Original Message-----
From: Jef [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, October 08, 2002 12:53 AM
To: [EMAIL PROTECTED]
Subject: [PHP] Database help


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?




Jef



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

================================================================
Deze e-mail is door E-mail VirusScanner van Planet Internet
gecontroleerd op virussen. Op http://www.planet.nl/evs staat een
verwijzing naar de actuele lijst waar op wordt gecontroleerd.




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

Reply via email to