php+mysql

if i do this:
mysql_query("SELECT id,game,release, from nexus order by release ASC");

it will print a table like this:

id game release
6 gangland 04.03.2004
7 sacred 23.03.2004
8 far cry 23.03.2004


So it orders them by date and by ID...

tried something like withouth success ('coz i'm a newb)
mysql_query("SELECT id,game,release, from nexus order by release ASC AND
order by game ASC");");

How can i get far cry to be before sacred (alphabetically)??

Thanks in advance ;)

-jK-

"Jari" <not@here.fi> schreef in bericht news:c2278h$pf8$1@news.cc.tut.fi...
> if i do this:
> mysql_query("SELECT id,game,release, from nexus order by release ASC");
>
> it will print a table like this:
>
> id game release
> 6 gangland 04.03.2004
> 7 sacred 23.03.2004
> 8 far cry 23.03.2004
>
>
> So it orders them by date and by ID...
>
> tried something like withouth success ('coz i'm a newb)
> mysql_query("SELECT id,game,release, from nexus order by release ASC AND
> order by game ASC");");
>
> How can i get far cry to be before sacred (alphabetically)??
>
> Thanks in advance ;)
>
> -jK-
>
>
try
mysql_query("SELECT id,game,release FROM nexus ORDER BY release ASC, game
ASC");

> try
> mysql_query("SELECT id,game,release FROM nexus ORDER BY release ASC, game
> ASC");

Thanks.. it worked ;)