[SOLVED] Any syntax problem with these queries?

[transparencia]

The queries are the following:

 

$query  = "SELECT *, u.name as uploader_name FROM #__attachments AS aa ";
$query .= "INNER JOIN #__users AS u ON u.id = aa.uploader_id ";
$query .= "WHERE aa.article_id='$article_id' AND aa.published='1' ";
$query .= "ORDER BY $order_by";

 

The queries above are suposed to do the same thing as this:

 

$query = "SELECT * FROM #__attachments WHERE article_id='$article_id' AND published='1' ORDER BY $order_by";

 

But adding a new feature.

 

Is there any syntax or other problem with the above queries?

[Barand]

mysql_query($query) or die(mysql_error());

 

will tell you if there is an error

[shlumph]

I'd suggest:
$query = "SELECT aa.*, u.name AS uploader_name 
	  FROM #__attachments AS aa
	  INNER JOIN #__users AS u ON u.id = aa.uploader_id 
	  WHERE aa.article_id='$article_id' 
	  AND aa.published='1'
	  ORDER BY $order_by";

[transparencia]

Great! Thanks shlumph, it worked! 

 

Barand: There was an error, it wasn't doing what it was supposed to do. But now it works just fine.