Jump to content


Photo

Search entry Expiration


  • Please log in to reply
1 reply to this topic

#1 anthonydamasco

anthonydamasco
  • Members
  • PipPipPip
  • Advanced Member
  • 92 posts

Posted 07 September 2006 - 08:47 PM

Well I have to make a "job search" for a temperary staffing company. What i have to do is make a control panel for staffing coordinators that will allow them to post jobs. That is the easy part. I have to set an option on the form to make this automaticly expire after a certian amount of days. Like if the job starts next week, I'll have it expire in 7 days.

can anyone help me figure out how this can be done?

#2 Gruzin

Gruzin
  • Members
  • PipPipPip
  • Advanced Member
  • 448 posts
  • LocationGeorgia

Posted 07 September 2006 - 08:56 PM

I think you should use Mysql autodelete:
<?
$today = date("YmdHi", time()); //or whatever date format you use
include('connectionStringInfo.php');
mysql_query("DELETE FROM events WHERE eventDate < '$today' ");
mysql_close();
?>

I don't need your script, I'll try to write it myself




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users