[SOLVED] Is there a way to do this or am I asking too much

[affordit]

What I would like to do is add an expire date that is 30 days out based on the Time_submitted value but I have no clue where to start can anyone help?

 

<?php

include("k_falls_dbinfo2.inc.php");

mysql_connect(mysql,$username,$password);

mysql_select_db($database) or die( "Unable to select database");

 

$query = "INSERT INTO test (name, time_submitted) VALUES ('$name', now())";

mysql_query($query);

mysql_free_result( $result );

mysql_close();

echo "All Done.";

?>

[affordit]

Is there a way to add days to the timestamp and then post the result to my table?

[resago]

strtotime()

[affordit]

I tried this line and it returns 1201820620

is there a way to add days to the now() function

$expire=(strtotime("+1 week");

[teng84]

???

 

now() of mysql will do it flawlessly..

all you need to do is insert the current date then query it something like

 

sample your field for the date is

my_date

 

 

all you need is a query that says

select * from table where DATEDIFF('now()','my_date') <=30; // returns all dates that is less than 30 days

does that help?

 

[affordit]

Yes that does help alot thanks what I am tring to do is get a expire date based on the start date to insert at the same time, then I can send email based on the expire date.

[cooldude832]

don't make it expire just simply don't display it after 30 days.

 

Then make your garbage collect cron job clean up old ads every week or so often.

[teng84]

 

I used now as expiration date you can also put what ever youwant

 

select (DATEDIFF('now()','my_date') -30) as days expire  from table where DATEDIFF('now()','my_date') >30;
//returns the number of days of expiration eg. if 31 1 day expired...
select DATEDIFF('now()','my_date') as days expire  from table where DATEDIFF('now()','my_date') >30;
// returns the total days of exiration eg 30 31, 32 etcc

 

maybe this?

[affordit]

don't I need to have an expire date to compare so that I can send emails to them that will include a renew option

[teng84]

how do you want your expiration date to be compared where will it come from?

[affordit]

I have a number of different subscription and I need to be able to generate a expire date based on when they signed up. I hope that made sense

[teng84]

you can add fields or tables.. that will have

expiration range and maybe expiration id

 

so to set it up you will have something like this

 

 

exId  Range

1        10

2        20

3        30

//ect...

 

select DATEDIFF('now()','my_date')as days expire  from table where DATEDIFF('now()','my_date') >Range and exId = 'youridhere';

 

does that makes sense?

[affordit]

So I set up new fields for id and range and the range would be the amount of days till it expires?

[teng84]

yes..

 

id would be the type of user  because the way i understand you diff user has diff expiration  so user type 1 expire 20 days and user 2 expire in 10 days etc...