ORDER BY error

[loony383]

In my database I have the collum called ORDER and it has numbers of the order, however when ever I try to order it in my while query it gived me an erorr.

 

		$navigation_sql=("SELECT * FROM pages WHERE hidden='0' ORDER BY order ASC");
	$navigation_query=mysql_query($navigation_sql);
	while ($navigation_fetch_array=mysql_fetch_array($navigation_query)) 
	{

}

 

This gived me this error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/loony383/public_html/index.php on line 27

 

[PFMaBiSmAd]

The php error "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource" is because you query failed and your code is not bothering to check if the query worked or not and is blindly attempting to access a result resource that does not exist.

 

Your query is failing because ORDER is a reserved keyword (as in ORDER BY). I recommend altering your table and changing the column named order to something else.

[Ken2k7]

Or change this;

$navigation_sql=("SELECT * FROM pages WHERE hidden='0' ORDER BY order ASC");

 

To:

$navigation_sql="SELECT * FROM pages WHERE hidden='0' ORDER BY `order` ASC";

 

Also, what's with people putting parentheses around strings?

[PFMaBiSmAd]

Back-ticks are mysql specific syntax and should only be used as a last resort as they make porting code to any other database a problem.