[SOLVED] PHP + MYSQL

[phorcon3]

could you actually group two different columns, and having one DESC and the other ASC?

 

for example:

$a = mysql_query("SELECT * FROM table WHERE columns GROUP BY column_1, column_2 DESC");

 

this will group both columns, and having them both in DESC order

 

but is there a way to have

 

column_1 ASC

 

and

 

column_2 DESC?

 

I would appreciate any help/comments on this. thanks!

[themistral]

I am not sure if it will work but try

 

$a = mysql_query("SELECT * FROM table WHERE columns GROUP BY column_1 DESC, column_2 ASC");

 

[phorcon3]

lmao ..yes it worked, thanks! just weird, cause ive tried it before, and it wouldnt work.

 

thanks!