Query help

For The Ultimate Quote hack by Kurafire, the quotes are shown randomly using this query.

PHP Code:

// random quote hack by KuraFire
 $quot=$DB_site->query_first("SELECT quote,name FROM quotes ORDER BY rand() LIMIT 1");
 $thequote = $quot['quote'];
 $thequoter = $quot['name']; 


how can I change it so it goes through all the quotes in order?

[They each have an id and ORDER BY id doesn't seem to be working :/]

Thanks

[geniuscrew]

Yup that's right Boofo

[Erwin]

Use this:

PHP Code:

$quot=$DB_site->query_first("SELECT quotesid,quote,name FROM quotes ORDER BY quotesid DESC LIMIT 1"); 


[Boofo]

Originally posted by Erwin
Use this:

PHP Code:

$quot=$DB_site->query_first("SELECT quotesid,quote,name FROM quotes ORDER BY quotesid DESC LIMIT 1"); 


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.

[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. :/

[Erwin]

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.

[geniuscrew]

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.

[Boofo]

Originally posted by geniuscrew
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.

[mr e]

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

[geniuscrew]

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.

[Boofo]

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.