MySQL & the LIMIT option

[acey99]

I know this may have been asked a 1000 or more times, but.....

anybody know how to use the LIMIT option with a select ?

$q=mysql_query("SELECT * FROM mytable LIMIT $top, $bottom");

Why is it when I have $top=11; & $bottom=20 it shows 1-20 ?

& I Want 11-20

is there a better way ?

[daynah]

$top = 10;
$bottom = 10;

$q=mysql_query("SELECT * FROM mytable LIMIT $top,$bottom");

The $top variable is what row you want to start your selecting from. (Note, The offset of the initial row is 0, not 1)

The $bottom variable is how many rows you want to retrieve.

You might want to read the mysql manual on select more.

I'm not sure why it's sending you all 1-20 rows... maybe your database only has 20 rows of data?

[acey99]

it actually has like 700 right now...