Random Image

[Xtremer360]

The purpose of this function is to go to the characters table and grab all of the characters that have a statusID of one however I want it to limit it to any ONE of those characters as this is a random image it's going to show and then I want it to have that charactes shortName and then use it to find their spotlight image from inside of the images/spotlight folder. All its showing right now in its spot is the the filename of the image when I call this function.

 

function spotlight(){
$query = "SELECT * FROM characters WHERE characters.statusID = 1 LIMIT 1";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
$labels = array('shortName');
    $img = array();
if($handle = opendir('images/spotlight/')) {
	$count = 0;
	while (false !== ($file = readdir($handle))) {
		if(strlen($file) > 2){
			$img[$count] = $file;
			$count++;
		}
	}
}
echo $img[rand(0, (count($img)-1))];
} 

[samshel]

SELECT * FROM characters WHERE characters.statusID = 1 ORDER BY RAND() LIMIT 1;

 

Will give u 1 random record

 

[Xtremer360]

Its still only echoing the name of the file and not the actual file.

[samshel]

try

echo "<img src='".$img[rand(0, (count($img)-1))]."' >";

[Xtremer360]

Thank you that worked but I just wanted to point out I had to add images/spotlight into the image src attribute so that it'll be the right location of the proper file.