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

[Boofo]

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

I think it would be ORDER BY DESC LIMIT 1

[geniuscrew]

That gives an error. I tried ORDER BY id DESC - but now it just shows the last quote added

[Boofo]

Originally posted by geniuscrew
That gives an error. I tried ORDER BY id DESC - but now it just shows the last quote added

Try this:

PHP Code:

ORDER BY quotesid desc LIMIT 1 


[Boofo]

If that doesn't work, maybe this will?

PHP Code:

ORDER BY quotes desc LIMIT 1 


[geniuscrew]

Still no luck - thanks anyway

[Steve Machol]

geniuscrew, to download hacks and get support you will need to go to this page and enter your email address, to show you are licensed. (you will need to use your customer number and password to access that page)
Thank you.

[geniuscrew]

sorry i just changed my email and fogot to update the thing -

Back on topic: can anyone help please?

[Erwin]

Take out the LIMIT 1 - that only limits it to 1 entry.

[Boofo]

I think they only want them to list 1 at a time but in order and not randomly, if I understood right, that is.