ORDER BY X then ORDER BY y

I need to order some data so that it displayes all the information with a cronological order of newest first:

I am using this:

select * from websites order by score DESC limit $offset,$limit

Now there could be 50/60 websites with a certain score, in this case the i want the latest websites at the top (the sql for this is oder by id DESC).

Is there a SQL command that could do this?

Really appriciate a quick reply.

Thanks,

if you got an autoincrement primary key...use it as order by criterium.
otherwise you have to use a timestamp.

bye,
nik

Humm, are you sure there is no easy way to do this?

ORDER BY id,score

(or is tht "score,id"...?)

SNAP

I just figured that out, the MYSQL site is some help 😉

Well thanks anyway, i may (will) need some more help later so keep an eye out😃

Thanks,