Help With Date Function

golfinggod

Hi All.

Im looking for some help in manipulating the date in Mysql and PHP. I dont have any code so ill try and explain it.

Im looking to use the date function to get todays date and use that as a starting point.

What i then need to do is create some code that uses that date to interact with stored dates in Mysql.

Basically i want to create some code that generates a report on last months stats.

Ive placed the select code below but im looking for some help in manipulating the date to one month ago.

////////////Get Todays Date///////////////////

$Date = date('Ymd');

$Newdate //////// Need This to be One month back///////////

 $Selectid2 = "SELECT Credits FROM credits WHERE Username = '$Username' & Date = '$Newdate"; 

      $Result3 = mysql_query($Selectid2);

Any ideas Thanks🙂

rupertbj

get today's date by using now()

golfinggod

Thanks for the reply. How does using the Now() function work in relation to getting last months date, im still learning and havent used that before.

AstroTeg

Check out this post from today: http://www.phpbuilder.com/board/showthread.php?s=&threadid=10266348

and then check out:

http://www.mysql.com/doc/en/Date_and_time_functions.html
(all sorts of nifty date/time functions available in MySQL as well as explanations and examples)