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. Quote Link to comment 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()); Quote Link to comment 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 ` ` Quote Link to comment 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. Quote Link to comment 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"); Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.