Limit data displayed

Anon

Hi,
In my mysql query,
I select * from table ORDER BY Date DESC LIMIT 30

this is so that I can just get the last 30 entries and display them.

However, I want to display then as ascending order, but since my query was in descending order, it displays my data in descending order.

How can I select the last 30 entries but still display the data in ascending order?

thanx

Anon

You could store the result in an array in PHP and reverse that array before outputting. Or you could query for the 30th most recent date and then use that date as in the where statement of another query to sort the last 30 dates in ascending order.

select * from table ORDER BY Date DESC LIMIT 29, 1;

then use the single date from that query and do

select * from table where Date='$dateof30th' ORDER BY Date LIMIT 30;

I remember someone else having this same problem not too long ago. I believe they said they went with the second method.

Anon

Does your table have an auto_increment field?

if so, you could add:

ORDER BY Date DESC, id ASC LIMIT 30;

Anon

This won't do what he wants as it will still sort everything in desc order BEFORE it tries to sort by id in asc order. Sort order matters.

Tim Frank

Anon

Does mysql support temp tables with select? If so, you could try,

select * from table into temp tmp_table order by date desc limit 30;

and then

select * from tmp_table order by date;

Anon

How do I put more than one mysql select statement into my code?
I have the following :

$result = mysql_query("SELECT *, UNIX_TIMESTAMP(Date) as Date FROM table WHERE Point = 'Fixed' ORDER BY Date DESC LIMIT 30",$db);

Do I need another $result or how else would I code it?

thanx

Anon

It depends completely on how you use the results of the queries.
If you need to use the result of the first query to run the second query
then you need to define new resultsets:

$result1=mysql_query("select bla");
$result2=mysql_query("update bla");

Otherwise, you dan just re-use your old resultset, which is overwritten the next time you call mysql_query.

Small note:
If you are running many querys and you are using a new variable for each resultset, it may be advisable to use mysql_free_restult to clear the memory used for your query-results when you are finished with the data.