> *Sorry if this is a duplicate*
> Using mySQL db to store my data. Using a select statement on my PHP page.
> When it lists out the data it seems to be skipping the first row. Any ideas?
Without seeing your code, I'll have to guess that you are accessing the 
result set once more than you think you are. This snippet from the manual 
shows how to use mysql_fetch_array; if you were to use another 
mysql_fetch_array before the while structure, you would get exactly the 
result you describe. If this isn't the problem, post your code.

   mysql_connect("localhost", "mysql_user", "mysql_password") or 
       die("Could not connect: " . mysql_error()); 

   $result = mysql_query("SELECT id, name FROM mytable"); 

   while ($row = mysql_fetch_array($result, MYSQL_NUM)) { 
       printf ("ID: %s  Name: %s", $row[0], $row[1]);   


Quod subigo farinam

A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet?

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to