Hello guys I have problem retrieving information in database using PHP in MySQL. I want to retrieve a specific row up to the the last row. like for example: I want to retrieve row 10 up to the last row. What query string should I use?
add id numbers to the table in the mysql and have them auto incremental. then call `id` >= '10 in your statement.
Or simply use LIMIT: SELECT * FROM blabla WHERE cond='val' LIMIT 10, 10 The first number is the start and the second is how many rows do you want.
Limit is probably a better way to go. If you end up deleting rows from the beginning for whatever reason then Limit will still start from the new tenth row where as the other method will still just look at the id.