Conditional Region by Date

Anon

Hi,

I'm trying to use the following conditional region to show or hide a table depending on today's date, and a future date stored in a database.
(Ignore the "Y", this is a conditional region I took from one of my pages... it's not an attempt at the current problem)

<?php if ($rsestatedetails->Fields("estate_date") == ("Y")) { ?>
<TABLE></TABLE>
<?php }
/ if ($rsestatedetails->Fields("estate_date") == ("Y")) /
?>

I have a date in a field(estate_date) in my database. What I would like is, when the date in estate_date is 30 or LESS days away from today's date, show the table. Now keep showing the table until the date in estate_date is behind(yesterday) today's date.(For a total of 30 days) Then hide the table again.

i.e. The date in the database = 2002-08-27
Today's Date = 2002-07-16 - Hide Table
Today's Date = 2002-07-29 - Show Table
Today's Date = 2002-08-18 - Show Table
Today's Date = 2002-08-28 - Hide Table

Can the above conditional region be modified to achieve this?

Thank you!

Peter

Anon

pull the date out as a UNIX timestamp then:

<?
$current_date = time ();
if ($current_date > $estate_date) {
$diff = $current_date - $estate_date;
}
else {
$diff = $estate_date - $current_date;
}
if ($diff < 2592000) {// show table}
else {// hide table}
}
?>

Anon

I'm new at this so bare with me :-)

Pull the date out as a unix timestamp..
In my SQL statement I have:

SELECT somefield, UNIX_TIMESTAMP(mytable.estate_oh1_date) AS estate_date, someotherfield.......

Is that the proper way to get the date as a unix_timestamp?(estate_oh1_date is the actual date-field in my table that holds a date like yyyy-mm-dd)

And this is what I'm placing in my page...

<?
$current_date = time ();
if ($current_date > $estate_date) {
$diff = $current_date - $estate_date;
}
else {
$diff = $estate_date - $current_date;
}
if ($diff < 2592000) {"Hello World"}
else {"Goodbye World"}
}
?>

Is the Hello World and Goodbye World in the right spot? Hello World being what would show if estate_oh1_date were less than 30 days away from today... and Goodbye World being what would show if estate_oh1_date where more than 30 days away, or is now yesterday.

The above code currently produces a PARSE Error. Should I not be calling for a recordset somewhere in the code near $estate_date?

THANK YOU THANK YOU!!! for your help so far. Sorry if I seem to be clueless.

Peter

Anon

The code you have there is fine but you need to iterate thru the result set:

<?
$result = mysql_query ("SELECT UNIX_TIMESTAMP(estate_oh1_date) AS estate_date FROM mytable");
$current_date = time ();
while ($row = mysql_fetch_assoc ($result)) {
extract ($row);
if ($current_date > $estate_date) {
$diff = $current_date - $estate_date;
}
else {
$diff = $estate_date - $current_date;
}
if ($diff < 2592000) {echo 'estate_date in this record is within 30 days of todays date<br>';}
else {echo 'estate_date in this record is not within 30 days of todays date<br>';}
}
?>

this code will go thru every record of the table and determine whether estate_date is within 30 days. If you want to filter the result set with only some records then you need to add a WHERE clause to the SQL code.

Anon

Thanks Devin,

This looks great. I just have one question along the lines of efficiency.

This code is going on a record details page, so I'm always concerned about a single record. But in that record I have to use this code to check 4 fields.. estate_oh1_date, estate_oh2_date etc..

So I'd rather not have to make a query to the database for each one. So what I'd like is in my main recordset "rs_estates", I've already pulled the unix_timestamp for all 4 fields.. now named estate_date_1 through estate_date_4

So instead of getting the value for $result by querying the database, I'd like to get the value from my recordset "rs_estates".

How would I replace the database query, with a simple request from my recordset?

Something like:
<?
$result = $rs_estates->Fields("estate_date_1");
$current_date = time ();
.............?>

Is that the proper way to get information from a recordset that's already on the page?

Thanks again for all your help Devin.

Peter

Anon

If all the dates in question are in separate fields in the same table then just pull them all out as before and run the 30 day check aginst each one inside the while loop.