[memobug]

I apologize for not knowing the ins and outs of your hack. However, I wanted to have a Quote of the Day that will remain the same throughout the day. I was thinking that this would allow people the opportunity to think about the quote, contemplate and reply to it rather than having different quotes fly by with every refresh.

I gather from the mysql I see that yours does not do this (from INDEX.PHP mod step 4a. in part:

SELECT * FROM quotes WHERE approved=1 ORDER BY rand() LIMIT 1

This appears to be a simple random query that would change on every refresh? Anyway, after researching this a little, I have the following suggestion as an alternative, using the date as a seed to give a consistent quote throughout the day:

SELECT * FROM quotes WHERE approved=1 ORDER BY RAND(TO_DAYS(NOW())) LIMIT 1

Which I believe will produce this result The problem I have found in other applications is: if someone adds a quote to the database, the quote of the day will shift because the total number of rows changes. At least that is what I have found to be true in another hack. This isn't necessarily a terrible result, but it is not the intended operation, and I would be interested if anyone knows a method to keep the quote random but changing daily.

Anyway if someone wants to try this it would be of interest to me. I am not currently using this hack, but would be interested in the result.

Regards,

Matt