LIMIT not working correctly?

[CadMonkey]

I'm running a query such as:

SELECT * FROM table ORDER BY field ASC LIMIT 0,10

to get the first 10 rows back. I'm gonna keep the 0 in this because it will change later.

It keeps omitting the first row.

I'm sure I've done it right. I've checked the query in phpMyAdmin and it works fine.

Any ideas?

 

[swampBoogie]

1) You have posted in the wrong forum. This one deals is SQL server.

2) If it works in phpMyAdmin, the error is propably in your code that retrieves and displays the data.

e.g. doing something like

$c = mysql_query($sql);
$r = mysql_fetch_array($c);
if ( $r ) {
  while ( $r = mysql_fetch_array($c) ) {
// display data
  }
}