Complex Multiple Sort

[Pollock]

I have a data base which contains 2 "date" fields and a character fields( actually about 30 or so other fields, but they do not relate to the problem). Problem I am running into is I need to pull only the first 30 most current date records based on date1 but then display them to the user order by either date2 or the character field. I can get the first 30 records which are correct, but then how do I reorder the now returned result set to reflect sorted by either date2 or the character field. Any help would be appreciated....

 

[sleipnir214]

Use one column in your WHERE clause, the other column in your ORDER BY clause.


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[Pollock]

The dates that initially ordered by are not chosen so a where clause would not work, basically the initial select uses " order by date1 next 30" so I don't have to worry about how far apart the dates are, as I only want the 30 most current and they could be two days apart or 6 months.

 

[sleipnir214]

Then add the column to the select, use it in the appropriate clause, but ignore it in your script.


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[sleipnir214]

What database system are we discussing here?


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[Pollock]

With regards to database, it is mysql...

Basically what I am looking for goes something like this

Select date1, date2,character1 from table table1 order by

either date2 or character1 but

for the 30 most current date1 records but

there is no date range for date1 I just want the 30 most

recent date1 records....