ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.

advertisement

AddThis Social Bookmark Button
Article:
  Using MySQL from PHP
Subject:   Results not displaying first record?
Date:   2005-12-01 02:57:31
From:   Electra
>sql query:


$result = mysql_query("SELECT * FROM `events`") or die(mysql_error());
while($row = mysql_fetch_array($result)) {
$ID = $row["ID"];
$Dt = $row["Dt"];
$Event = $row["Event"];


echo $Dt . "$nbsp;nbsp;" . $Event . "
";
}


>There are 3 records in the database, but only records from the 2nd row are displayed. Using mysql_fetch_row($result) displays nothing? I've also added LIMIT 0,30 to the query to try and force the first row, but with no luck.


1 to 1 of 1
  1. Results not displaying first record?
    2006-02-20 06:11:02  amjohnno [View]

1 to 1 of 1