marcus.whybrow Posted February 7, 2007 Share Posted February 7, 2007 Ok, im creating a simple bit of PHP that shoul just order whats in the database. The error messag I keep getting is: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /srv/www/scriptsoft.co.uk/php/index.php on line 48 <?php $con = mysql_connect("localhost","----------","----------"); mysql_select_db("scriptsoft", $con); $cat = mysql_query("SELECT * FROM cat ORDER BY order"); while($mainrow = mysql_fetch_array($cat)){ //line 48 print $mainrow['text']; print "<br />"; } ?> I've done this many times before and it has worked perfectly, I just cant see what the problem is, any help will be greatly appreciated. Thanks, Marcus. Link to comment https://forums.phpfreaks.com/topic/37383-solved-while-loop-not-working-why/ Share on other sites More sharing options...
fert Posted February 7, 2007 Share Posted February 7, 2007 change $cat = mysql_query("SELECT * FROM cat ORDER BY order",$con) or die(mysql_error()); Link to comment https://forums.phpfreaks.com/topic/37383-solved-while-loop-not-working-why/#findComment-178706 Share on other sites More sharing options...
jcbarr Posted February 7, 2007 Share Posted February 7, 2007 you need to have this more then likely; ORDER BY `order` You are confusing the SQL server when you don't enclose it in ` ` Link to comment https://forums.phpfreaks.com/topic/37383-solved-while-loop-not-working-why/#findComment-178718 Share on other sites More sharing options...
Hypnos Posted February 7, 2007 Share Posted February 7, 2007 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /srv/www/scriptsoft.co.uk/php/index.php on line 48 That means the MySQL result set was empty. Double check your query string. Your PHP code is fine. Link to comment https://forums.phpfreaks.com/topic/37383-solved-while-loop-not-working-why/#findComment-178729 Share on other sites More sharing options...
13th_Star Posted February 7, 2007 Share Posted February 7, 2007 change: $cat = mysql_query("SELECT * FROM cat ORDER BY order"); to: $cat = mysql_query("SELECT * FROM cat ORDER BY order DESC"); Link to comment https://forums.phpfreaks.com/topic/37383-solved-while-loop-not-working-why/#findComment-178753 Share on other sites More sharing options...
marcus.whybrow Posted February 8, 2007 Author Share Posted February 8, 2007 Ok it was the ORDER BY order thing, when i got rid of it it worked fine, Thanks for all the posts. Marcus. Link to comment https://forums.phpfreaks.com/topic/37383-solved-while-loop-not-working-why/#findComment-179631 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.