Order by Date then ID

[LB]

I have a query that orders things by date. The database itself only has
dates in it, not times, so what I want to do is find items in the
database by date, then by ID - so that the latest item always comes out
first (hope that makes sense!).

Can you set the order twice within the same query?

LB

[Steven]

> Can you set the order twice within the same query?

>

I think you can.

ORDER BY date AND id

Give it a try and you will find out.

Good luck!


--
Posted by [url]news://news.nb.nu[/url]

[LB]

Steven wrote:

>>Can you set the order twice within the same query?
>>

>
> I think you can.
>
> ORDER BY date AND id
>
> Give it a try and you will find out.
>
> Good luck!

Thanks Steven,

Tried that, but doing it that way for some reason took out the date
sorting altogether (or at least seemed to). So I tried;

ORDER BY DATE ASC AND ID ASC

But that threw an error :-(

[Steven]

> Tried that, but doing it that way for some reason took out the date
> sorting altogether (or at least seemed to). So I tried;
>
> ORDER BY DATE ASC AND ID ASC
>
> But that threw an error :-(

Hmmm try this :

ORDER BY date DESC, id DESC
This should work.


--
Posted by [url]news://news.nb.nu[/url]