thanx allllllllllllot
its great :)

Glad you like ^_^

You're not alone -_-

Mine just sits on ID 1 and once in a blue moon changes to ID 2

Edited: Well it changed to all of them after loads of refreshing.

I know this may sound stupid but how do I get it to get a quote in order?

doesn't work :/

You need to change the RAND() to RAND(NOW()) to make it more random with the new versions of mySQL since version .54

The NOW will seed it and make it more random that it was before.

Well it's changed - but now it's sitting on a different one -_-

Any confirmed resolution to the above problems before I install this on my new update? I love it, I just want to make sure it randomizes properly. :)

-Jason

It should work just fine - if it doesn't, it's more likely a problem with your server than the script, really :)

Okay I shall test and report back!

-Jason

Wheres the latest file for this?

I'm having the stuck on a quote problem as well.

At first I had the template called only for users who were logged in (I had done this inadvertantly by putting the call for the home_randomquote template right after the IF statement to test for users.) When it was setup this way, the quote was perfectly random ... However, When I discovered this, I moved the call out side of the user logged in conditional, and it no longer randoms. It stays on the first quote for both logged in and logged out users. I've tried moving it throughout my index.php

Any ideas?

**I FIXED MY PROBLEM**

Changed the random seed by using the following:

srand((double)microtime()*1000000);

$random_number = rand(1,147);

$quot=$DB_site->query_first("SELECT quote,name FROM quotes WHERE id = '$random_number'");

**************

however, you should change the 1,147 to represent the number of quotes you have (this is the range of the random number selected I believe).

I think you can stick in a query to get the number, but i just hard code it...

Good luck !