Jump to content

Random Image


Xtremer360

Recommended Posts

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))];
} 

Link to comment
https://forums.phpfreaks.com/topic/228845-random-image/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.