Re: [PHP] Database help

2002-10-08 Thread Jef
The code works fine for displaying the information in the database. However, the first line of information is still skipped. Jef ++ Davy Obdam [EMAIL PROTECTED] wrote in message

RE: [PHP] Database help

2002-10-07 Thread Davy Obdam
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;$imysql_num_rows($sql_id);$i++) { $useFields = mysql_fetch_assoc($fSql);