[SOLVED] Date

[shage]

I have a database that has a date such as 2007-12-01 with a inactive colum, what is the best way to have it make that cell active on the date that is in the date cell? So on 2007-12-01 that site would be active. Thank you

[toplay]

I have a database that has a date such as 2007-12-01 with a inactive colum, what is the best way to have it make that cell active on the date that is in the date cell? So on 2007-12-01 that site would be active. Thank you

 

You really got to expand on what you mean and want to accomplish, I'm not sure if you're asking for a MySQL help or PHP related help.

 

What does "cell" mean and "that site would be active" mean?

 

[smc]

A cron job is really your best bet. Just run a cron that says

 

<?php

if( strtotime( $mySQL ) >= time() ){

    $sql = mysql_query( "UPDATE myTable SET activityColumn = 'true'" );

}
?>

 

Or along those lines

[shage]

I have a database that has a date such as 2007-12-01 with a inactive colum, what is the best way to have it make that cell active on the date that is in the date cell? So on 2007-12-01 that site would be active. Thank you

 

You really got to expand on what you mean and want to accomplish, I'm not sure if you're asking for a MySQL help or PHP related help.

 

What does "cell" mean and "that site would be active" mean?

 

 

the sites are inactive until the date, now looking to make the site active on the date in the table