Can't get "order by" to work in this string...

[jonw118]

Hi there - can anyone lend me a little advise as to what I'm doing wrong here.

 

I have this line:

$query=mysql_query("SELECT * FROM gallery a JOIN gallery_image b ON a.id = b.gallery_id where gallery_id=$gallery_id");

 

I am trying to add an order by statement: order by gallery_image.priority

 

So I created:

$query=mysql_query("SELECT * FROM gallery a JOIN gallery_image b ON a.id = b.gallery_id where gallery_id=$gallery_id order by gallery_image.priority");

 

But, I receive the error (even though there is table called "Gallery Image" and a column called "Priority":

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/***/public_html/***/gallery.php on line 5
select: Unknown column 'gallery_image.priority' in 'order clause'

[bh]

Maybe becouse you use an alias... ?

$query=mysql_query("SELECT * FROM gallery a JOIN gallery_image b ON a.id = b.gallery_id where gallery_id=$gallery_id order by b.priority");

[aeroswat]

That doesn't seem like good practice to not use the AS keyword

[TOA]

Try telling it how to order by -- ASC or DESC

 

 

[aeroswat]

Try telling it how to order by -- ASC or DESC

 

Won't matter. It defaults to Ascending