Doubt in Offset
I have a table called "HelpingHands".
I have many records in the table. [I dont know the total number of records it may increase or decrease]
and i want to retrieve the last 1000 records in the table.
i used select * from HelpingHands limit (ABC),1000;
I dont know wot to substitute in the place of ABC.
Thanx in advance
You will have to order by a certain field
(ie a datetime field, the primary key etc)
and then limit the records
Example with a datetime column