rand() image.. Please help...

kpowning

Can anyone please help me with this. I'm trying to get a random image to display on refresh of the page, and for some reason all I keep getting is the same one over and over.. I would appreciate any help or ideas on this.

My script:

$bannerad=$DB_site->query_first("SELECT * FROM banner ORDER BY RAND()");

Please note: My table uses a unique column named "id" this is for the name of the images. They are listed as integers from 1 and up. I need a simple rotator script if nobody has any ideas on this one. Please help me. I have spent many hours trying to get this thing to work and nothing is doing it.😕 😕 😕

PHPdev

Not completely sure what the issue is, but a couple of solutions you may try is limiting the number of results use LIMIT 1

There are always other solutions...

PHPdev

spirp

That wierd.. I tried that myself, and got it to work prefectly.. Don't know why it doesn't work for you.. :\

If you don't get this working, you could do it like this:

$q = "SELECT max(id) FROM banners;";
/* perform the query and store the result in $result */
...
/* done */
$random_id = rand(1, $result);

/* now select the image */
$q = "SELECT * FROM banners WHERE id='$random_id';";
/* perform the query... */

That ought to work..

Good luck,
Olle

kpowning

Thanks for the response, but I have tried the limit variable as well. The problem is that it keep calling the same image up with no rotation on the page.. I need a script or this code to work so their is a random image rotation. Please help..

spirp

Hmms, dunno but the problem might originate in caching of webpages done by the webbrowser?

As I wrote, I don't have any problems when I run the SQL-query directly in the MySQL client.. Haven't tried it using PHP though..

Good luck,
Olle