Jump to content

ORDER BY error


loony383

Recommended Posts

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

 

Link to comment
https://forums.phpfreaks.com/topic/156653-order-by-error/
Share on other sites

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.

Link to comment
https://forums.phpfreaks.com/topic/156653-order-by-error/#findComment-824891
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.