Yup that's right Boofo :)

Use this:

I was close. I forgot to do the first quotesid (actually I didn't know it had to be done that way). ;)

Let me know how it works, geniuscrew.

Actually Boofo even though you didn't say, I was putting the id bit in the SELECT part [at the beginning] ;)

Still it's only showing the last quote. :/

That is because that is what you wanted. The query chooses the very last quote listed.

Change DESC to ASC will make it choose the first quote listed. But it will not be random. It will always choose the first quote, or last quote.

So there's no way of making it go through the list of quotes and display them one by one?

If not how do i make it even more random?

Thanks for the help guys.

Use RAND(NOW()) in place of RAND like I posted earlier in the thread. The NOW() supplies the necessary seed for the newer versions of mySQL. Trust me. It works. ;)

you could add another column that would display if it's been listed yet, not sure how to make it more random though

Mr E: But would that let the same quote be used twice?

Boofo: Is that the most randomest of randoms? :) I did try it before ya know and it worked, but wasn't what I was looking for. But I'll use it :P


Thanks ppl.

According to the mySQL site, that is more random than the old way (with RAND() alone) ever was. The seed needs to be there now and this is the automatic way to do it. It's all I use anymore and I have noticed a world of difference. But then I have over 642 quotes, so that helps. I use this for the member of the day hack and it makes a big difference there, too. Try it for a few days and let me know what you think. You will be amazed. ;)