Quote of the day

Anon

I am storing quotes in a database, now I want to make a quote of the day generator (not a random !), how is this done ?

I have got this:

$ret= mysql_query("SELECT kwoot FROM kotd where uid=$number ") or die(mysql_error());

and $number should be different for each day, but in between 0 and mysql_num_fields of the table

Simple said, it should do +1 every day, and when it reaches the limit, it goes back to 0

I would prefer and option without adding another table to the database or so ...

Maybe store the $number var. in a file, I don't really know, can someone help me ?

Anon

There are a number of things you could do, I'd imagine. One would be to have a separate table that stored the date and the id #? You could do a check on this table, make sure that the date is the same as todays date and if it is select using the id #... if not, add one to the id # and THEN select the quote using the new ID.

$ret= mysql_query("SELECT kwoot FROM kotd where uid=$number ") or die(mysql_error());

[deleted]

Or you could add one field to your table that holds a char or an int that identifies the record as "has been displayed"

When you select a kwoot (to display it or whatever)
you just grab the first record that is not marked as "displayed" (remember to order the select!)

When you want to move to a new kwoot, you fetch the ID of the "current" kwoot as described above, and update it to mark it as "displayed"

When all records are marked, you update the table to remove all the marks and it starts over.

mp96brbj

I ran into the same problem and wrote this, which might be of help:

$num_quotes = 15; / Insert your mysql_num_rows or something here. /
$seed = date(z); # Day of the year.
$id = $seed - floor($seed/$num_quotes)*$num_quotes + 1;

This will make $id start at 1 on Januray 1st, and become 2 on January 2nd and so on until it's 365 (or 366) on December 31st. Then it will restart. But if you have, say, only 15 quotes stored, they will loop back to 1 on January 16th and so on.

If you add a quote sometime during the year, the current day's $id will change.