How would I make an item appear for a certain time?

Drebin

I've made a basic classifieds ad script and I'd like to add a feature that would automatically delete ads after 30 days. How would I do this?

sid

i suggest you start by getting familiar with unix timestamps and [man]date()[/man]

Drebin

I'm familiar with the unix timestamp and date() function.

I created a row in my database for the date and instead of using Timestamp I made it an integer.

Here's part of my code:


 $date=mktime();

  $query2="INSERT into classifieds_ad (classifieds_Name,classifieds_Ad,classifieds_category_ID,classifieds_m_date) values ".
       "('".$_GET['classifieds_Name']."','".$_GET['classifieds_Ad']."','".$_GET['classifieds_category_ID']."','$date')";

The correct date is posted when an item is listed, I just don't know how to select items that have been posted within 30 days.

sid

calculate the unix timestamp of RIGHT NOW and subtract 60 (secs) 60 (mins) 24 (hours) * 30 (days). this should give you an integer value. then select from ther database all the rows that have a unix timestamp that is bigger than the value you just calculated. take it easy!