[SOLVED] while loop not working. WHY!

[marcus.whybrow]

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.

[fert]

change

$cat = mysql_query("SELECT * FROM cat ORDER BY order",$con) or die(mysql_error());

 

[jcbarr]

you need to have this more then likely;

 

ORDER BY `order`

 

You are confusing the SQL server when you don't enclose it in ` `

[Hypnos]

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.

[13th_Star]

 

change: $cat = mysql_query("SELECT * FROM cat ORDER BY order"); 

 

to: $cat = mysql_query("SELECT * FROM cat ORDER BY order DESC"); 

[marcus.whybrow]

Ok it was the ORDER BY order thing, when i got rid of it it worked fine,

 

Thanks for all the posts.

 

Marcus.