Inserting from MySql at a given date

[Anon]

How can I make my PHP page fetch a row from a database at a date/time defined in the row?

What I would like is a word on the front page that changes auomaticly once a week.

Thanks!

[smarlowe]

Try something like this:

number your rows with an id from 1 to 52 (one for each week) then just do something like this (warning, not tested code, but you get the idea)

$jul=date("z"); # z returns julian date
$week = int($jul/7)+1;
$query = "select * from table where id=$week";

[jcleary]

yes, or a shorter version

$query = "select * from table where id = week(curdate())"

John

[Anon]

Thats perfect!

But I would also like it to send an e-mail notification to members when a new words is posted each week. Is that possible? The memeber names and e-mail addresses are stored in a database aswell.

Thanks again!