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]

Ah- Hah - I thought I needed to add more quotes - I only have 4 and now it's sitting nicely ont the second one -_- - I'll add more and get back to ya.

Thanks for all your help and for putting up with my annoyance for that matter lol

Peace.

[Boofo]

No problem. Happy to help. Keep me posted.

[mr e]

@geniuscrew you'd add another column with default of 0 then after it's displayed the quote the column would be set to 1, after all the columns are one, then all columns would be set back to 0 and everything would start over again

[Erwin]

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

To make it go down the list one by one, you need to make your site remember each member somehow, and remember which quote they have looked at, store it, so that the next time they return, the site can go to the next quote.

You can do this by adding a new column to the user table, and saving the quoteid that the member has looked at, and just add 1 after that OR use cookies to save the information.

Either way, it can be done, but would take some effort.

[geniuscrew]

Thanks Mr E and Erwin. Unfortunately I don't have the brains to do that kinda stuff.