loony383 Posted May 3, 2009 Share Posted May 3, 2009 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 More sharing options...
PFMaBiSmAd Posted May 3, 2009 Share Posted May 3, 2009 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 More sharing options...
Ken2k7 Posted May 3, 2009 Share Posted May 3, 2009 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? Link to comment https://forums.phpfreaks.com/topic/156653-order-by-error/#findComment-824980 Share on other sites More sharing options...
PFMaBiSmAd Posted May 3, 2009 Share Posted May 3, 2009 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. Link to comment https://forums.phpfreaks.com/topic/156653-order-by-error/#findComment-824991 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.