Hello,

Im currently doing a random iamge script/system

Ok, the guy is currently using this script:

PHP Code:

<?php
/*
By Matt Mullenweg > http://photomatt.net
Inspired by Dan Benjamin > http://hiveware.com/imagerotator.php
Latest version always at:
http://photomatt.net/scripts/randomimage
*/// Make this the relative path to the images, like "../img" or "random/images/".
// If the images are in the same directory, leave it blank.
$folder = 'upload/';
// Space seperated list of extensions, you probably won't have to change this.
$exts = 'jpg jpeg png gif';
$files = array(); $i = -1; // Initialize some variables
if ('' == $folder) $folder = './';
$handle = opendir($folder);
$exts = explode(' ', $exts);
while (false !== ($file = readdir($handle))) {
foreach($exts as $ext) { // for each extension check the extension
if (preg_match('/\.'.$ext.'$/i', $file, $test)) { // faster than ereg, case insensitive
$files[] = $file; // it's good
++$i;
}
}
}
closedir($handle); // We're not using it anymore
mt_srand((double)microtime()*1000000); // seed for PHP < 4.2
$rand = mt_rand(0, $i); // $i was incremented as we went along
header('Location: '.$folder.$files[$rand]); // Voila!
?>

and has <img src="randomscript.php" />

this script selects a random image form the folder and shows..

im now making the whole uplaod and a moderation system for this
and im planning to have a simple db table with

ID | imagefile | status

on upload it auto inserts a entry with the filename.ext and the status as moderate or soemthing...

then have a thing so once image has been checked ut updates status...

anyway... ]

so how can i have the above script select a random image which has a status of live (or whatever i choose) and also possibly add a check that it exists.

i mean i can do the sql query and if exists check its just im not sure how to go about getting the result of these files and then haveing it select on at random???

I hope you get what i mean here! because i jsut confused myself.

Anwyay thanks
Tp for good answers!

Dan

Okay i have all the dba nd everything done now, so i just need to know the best way to get all the image_name's (which is image.jpg format) and have the scrpt randomly slect one

HEELP ANYONE!!!

Anyone...

how do i go from

$image_query = mysql_query("SELECT image_name FROM images WHERE status='approved'") or die("Error getting iamge info from DB");

to the script randomly selecting one of the images which fit into the status approved cat?

Try this:

 SELECT
    image_name
FROM 
    images
WHERE 
    status='approved'
ORDER by RAND()
LIMIT 1;

Thanks alot, works a treat!

given you TP ! XD

now all i have to do is knock upa aadmin bit and im DONE!!

Upload the files using a form then have your form store the name of the file in the database and upload the file

Please read the thread John... it makes you look very stupid.

Firstly i have explained i have all the upload done and it adds it to the database my problem was i didnt know how to select a random entry from the db...
Kuldeep2195 gave me a answer, i gave him TP. i praised him thanked him and said it worked...

So not only have you not read the thread and given a answer which doesnt fit the question you are also replying to a thread which is done and dusted.

Dan

Not what I ment

I meant make a form that will do it for uploading or create an array of the file names then add them to a DB

To everyone ecept John:

Am i missing something? seriously? or is he still answering a question i wasnt asking??? :P

I'm lost trying to figure it out

nope, you're not missing anything dansgalaxy. John is really answering a question that you're not asking. You would think if he had even read the title of the thread he'd understand what it was about.

Thanks.. im glad its not just me, i swear i was this close ii <- to taking TP off him i was like O_O you have to be kiddin' me.. Lol