Image

Imagesourpatchkid wrote in Imagephp

I'm getting a
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
error with this code...

for($i = 1; $i < 11; $i++){
	$place_select.$i = "SELECT sum(place) FROM sng WHERE place = '".$i."'";
	$place_result.$i = mysql_query($place_select.$i) or die('amount caused death');
	
	$place_total.$i = mysql_fetch_array($place_result.$i);
}


There are only 10 places (1-10) and I want to count each time the person finished in each place..

for($a = 1; $a < 11; $a++){
        echo $place_total.$a[0];
        echo "<br />";
}


Someone please point out what I'm missing...