limit return to last 50 records

[fran7]

Hi,

This apparently limits the return to the first 10 records

mysql> SELECT * FROM search LIMIT 0, 10;

How do you limit the return to the last 50?
Would that have to b done by date?

Thanks for your help
Richard

[omerbutt]

Yes that can be done in 2 ways
1-with the date part
2-by moving to the last rec in the db

FOR 1 THE DATE PART:
you can do it with the date by first getting the current date and then calculating
the difference of the days but wait how could u guarantee that only 1 rec would be entered in the database for each day so that u calculate the last 50 records by moving back 50 days from the current date[:)].....soooooooooo it wont be aplicable in the case
FOR 2 THE LAST REC PART
Hmmmmmm........this seems to be solving the problem [:)] first u should go to the last rec in ur db by the following way i would specify the pseudo type coding u can use it in ur asp page with modification
for i to recordsize......(get the recordsize by using "recordsetobj.Recordsize")
recordsetobj.movenext
Loop
if ((recordsetobj.EOF)=="TRUE")-----or/-------if ((recordsetobj.BOF)=="FALSE")
{
for i=1 to 50
Response.Write recordsetobj("dbFieldName")
recordsetobj.MovePrevious
Loop
}
HOPE THAT MIGHT SOLVED UR PROBLEM [:)] TCZZZZZ

Hi,

This apparently limits the return to the first 10 records

mysql> SELECT * FROM search LIMIT 0, 10;

How do you limit the return to the last 50?
Would that have to b done by date?

Thanks for your help
Richard