Re: [PHP] Database help
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 000801c26e63$8622cb00$960a@davy">news:000801c26e63$8622cb00$960a@davy... > 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 { > $useFields = mysql_fetch_assoc($fSql); > file://Your table > echo "".$useFields['lot'].""; > file://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
RE: [PHP] Database help
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".$useFields['lot'].""; //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
[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