[RESOLVED] stampdate + adding days

vinny199

Hi,

I am a bit confused about how to do this:

I have a Users table with a registration date: $date set as a stampdate, and when they first register a stampdate gets imputed: YYMMDDHHMMSS

now I get then to choose a package for which they pay, and if payment is successful I would like to add the number of days from the package they bought and add it to the original stamdate to store it in a secont users table field $expiredate

I get it all to work ok, but how do I get to add $package_days (which is a value such as 15 0r 30 or 45 etc. and are days) to my stampdate value to create the new data for $expiredate?

Many thanks if you can help.

bpat1434

You can do it all in mySQL (since your using a mySQL formatted date-time stamp).

The functions are listed HERE and the one you want is "DATE_ADD"

vinny199

ok, thanks, i've been reading these and a few other bits and pieces related to DATE_ADD and could figure out that this :

mysql_select_db($database_to_octo, $to_octo);
$query_rsdate = "SELECT DATE_ADD(stampdate ,INTERVAL (1-MONTH(stampdate)+1) MONTH) FROM users";

is a step forward towards what I need to do, as the way I understand it, this will add 1 month to my $stampdate

Ultimately, I'd like to replace the +1 with:

+"$package_month"

"$package_month" being a value from 1 to 12 but stored in a different table : packages

i hope this will be possible and that $query_rsdate can retrieve a value from another table to do what I describe.

But thats another step I guess,

My immediate concern (I know it sounds daft..) is how do I get my $query_rsdate to print the result on my page? since I'm not just retieveing a row from my database, but a modified one?

thanks,

Vinny

Installer

Use a MySQL alias "(SELECT DATE_ADD(etc., etc.,) AS something..." then when you fetch the results you can get the alias just like a regular column.

vinny199

ok, thanks, I get that.

my second issue is to get

$row_rspackages['package_month'] from my table : packages to replace the :

$query_rsdate = "SELECT DATE_ADD(stampdate ,INTERVAL (1-MONTH(stampdate)+1) MONTH) AS test FROM users";

so my "month multiplier value is taken dynamically from the packages table.

I have tried:

 $query_rspackages = "SELECT * FROM packages WHERE package_month = 2";

and then:

$query_rsdate = "SELECT DATE_ADD(stampdate ,INTERVAL (1-MONTH(stampdate)+"$row_rspackages['package_month']") MONTH) AS test FROM users";

and get a parse error.

I have also tried to make a

$addedmonth = $row_rspackages['package_month'];

and then

$query_rsdate = "SELECT DATE_ADD(stampdate ,INTERVAL (1-MONTH(stampdate)+"$addedmonth") MONTH) AS test FROM users";

both these return a PARSE ERROR.

Where am I going wrong please?

vinny199

ive worked it out.

Thanks again.