Quote:
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