Can Anyone See A Problem With This Select Query

[golfinggod]

Hi Can anyone see a problem with this select query

/////////////////////////////////////////////////////////////		  

///// Step 2 Randomly Select Data For Banner ////////////////

$Fetchbanner = "SELECT * FROM banners WHERE Bannercatagory = $Catagory & Bannersize = $Bannersize order by rand() limit 1"; 

$Result = mysql_query($Fetchbanner); 

$Row = mysql_fetch_array($Result); 

$Bannerowner = $Row ['Username'];

$Bannerurl = $Row ['Bannerurl'];

$Imageurl = $Row ['Imageurl'];

$Bannername = $Row['Bannername'];

It Keeps Stating This

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\phpdev\private\page\pages\engine460.php on line 39

[AstroTeg]

Remember, mysql_error() will always be your friend.

This SQL segment doesn't make sense:

order by rand()

rand() is a function. It returns a random number. Order of operations dictate that it figures out the number first and then does the order by. So what you are really saying:

order by [field named: random number selected by rand()]

But I bet your fields are not numeric. Order by can only sort by field names.

order by [existing field name] <-- will work

[drawmack]

you can order by rand() however I'm guessing that one of your where clause fields is not numeric and therefor is causeing the error because they are not quoted.