LIMIT is not "limiting"

[baffled_in_UK]

Hi,

Can anyone tell me where I'm going wrong, this code is suppose to get and print the first ten records only but it doesn't stop at ten but gets all the records that match.

 
<?php

//  ---- db connect -----//


$result = mysql_query("SELECT * FROM table1 WHERE field = 'Y' ORDER BY date1 LIMIT 0,10",$db);


if ($myrow = mysql_fetch_array($result)) {
  do {

//---  record print stuff -----------//

} while ($myrow = mysql_fetch_array($result));

}


?>

Thanks

[Chris_78]

I know this is a little more than you're looking for but, here's what I use... This will actually limit it to 10 records and then put a "Next" link at the bottom of the listing..

<?php

//  ---- db connect -----//

$limiter = 10;
if(!$page)
  $start = 0;
else
  $start = ($page-1)*$limiter;

$sql = "SELECT * FROM table1 ORDER BY blah LIMIT $start,$limiter";
$result = mysql_query($sql);

//---  record print stuff -----------//

if(!$page)
    $next_page = 2;
  else
    $next_page = $page + 1;


  print "<a href=\"" . $PHP_SELF . "?page=" . $next_page . "\">Next >></a>";

?>

Hope that helps!

[baffled_in_UK]

Thanks for the reply.

I would still like to know what I'm doing wrong though.