[RESOLVED] MySQL constantly displaying one less than in database

[jme]

This is something weird that I can't work out. I am developing something using a localhost installation of Apache2, MySQL, PHP on MacOSx.

Within my scripts, anytime I call a 'select from xxx' the first item is lost and not presented. For example, if I do a 'select from xxx' then the first item by the primarykey is missing, if I spcify a order by then the first on is lost in that so it's not the same thing that's being dropped.

mysql_num_rows($result1) shows the correct number I am expecting, but when a while script is used to print them, one is always missing.

Any ideas?

Cheers guys. Jamie 🙂

[harmor]

What is query that is giving you problems?

[jme]

Problem solved -- I was being very silly. There was a

$row1 = @mysql_fetch_array ($result1, MYSQL_ASSOC); 

before the while statement causing the loss of the first! 🙂