My Sql Select

[iceraider]

 $result = mysql_query("SELECT * FROM banners WHERE id='$rand'",$db);
 $all = mysql_fetch_row($result);

When I run that code, and $rand is equal to the right id number. Why doesn't the array all contain anything? What did i type wrong here, for making a array equal to the row im pulling out

[planetsim]

I see nothing wrong there except try doing this

$result = mysql_query("SELECT * FROM banners WHERE id='$rand'",$db)or die(mysql_error());
$all = mysql_fetch_row($result)or die(mysql_error());

That can help you. Most Likely you'll need to get rid of $db and the ,

[diego25]

Also, most likely the id field is an integer, so you don't need quotes around $rand.

Diego