Using "Limit"

[Ham]

I'm trying to return 10 rows from a table starting at a primary key id with this query:

 

select * from table_name limit $primary_key, 10;

 

...but it does not work.

 

Please show me how!

 

 

Thanks,

 

Ham

[ryanlwh]

the limit x,y syntax only works with offsets (row number). If there was no deletions in your table, this would work fine, but if some items were deleted, an id would not be the correct offset anymore.

 

maybe this is what you need:

SELECT * FROM table_name WHERE id >= $primary_key ORDER BY id ASC LIMIT 10;