timed content

[kev69]

I have a database containing a table where each record has a text block and 2 dates. The 2 dates are the start and end times for when the text block needs to be displayed, for example one week the text in one record appears the next week the next record appears.
The trouble is I can't find a way to write a MySQL query that selects the record where todays date lies between (and including) the start and end dates.
Any one got any ideas?

[rontgoff]

I have had the same problem, what helped and made it very simple to do is insted of making one date field make a month field a day field and a year field for your start and end dates

Then your code could look like this

$month_start = (month placed in db);
$day_start = (day placed in db);
$year_start = (year placed in db);

$month_start = (month placed in db);
$day_start = (day placed in db);
$year_start = (year placed in db);


$sql=mysql_query("SELECT * FROM news WHERE (month='$month_start' AND year = '$year_start' AND day >= '$day_start') AND (month ='$month_end' AND year = '$year_end' AND day <= '$day_end'");

This would give you every thing between those days.

if you had:
$month_start = 12
$day_start = 12
$year_start = 2002

$month_end = 12 
$day_end = 20 
$year_end = 2002

it would give you all the news from the days 12 - 20.

Hopefully this helps

[kev69]

Originally posted by rontgoff

$month_start = (month placed in db);
$day_start = (day placed in db);
$year_start = (year placed in db);

$month_start = (month placed in db);
$day_start = (day placed in db);
$year_start = (year placed in db);

[/B]

Do you mean

$month_start = (month placed in db);
$day_start = (day placed in db);
$year_start = (year placed in db);

$month_end = (month placed in db);
$day_end = (day placed in db);
$year_end = (year placed in db);

[kev69]

😃
thanks rontgoff, i didn't do exactly like you but your idea got me onto the right track and it works now

[rontgoff]

Sorry thats what I ment glad I could be of help

[jonsof]

Is there any other solution using sql statement?

Something like "now()<=expired_date"