Adding Date Member Status Changed

[tomyknoker]

I have a php page where I can change the status of members in my database from 'Pending' to 'Approved', when I change a member to 'Approved' they receive an email... I want to also add a date when I change them, so once they are approved a date is added into a column in my database... If anyone can give me an idea that would be great! This is what I have so far...

mysql_query("UPDATE `tblmembers` SET `MemberApproved`='$status' WHERE `ID`='$id'");

//get Member Info
$userInfo = mysql_query("SELECT * FROM `tblmembers` WHERE `ID`='$id'");
$q = mysql_fetch_array($userInfo);

//get Email info
if ($status == "A") {
$emailInfo = mysql_query("SELECT * FROM `email` WHERE `email_id` = 'A'");

$stat = "Approved";
}

elseif ($status == "R") {
$emailInfo = mysql_query("SELECT * FROM `email` WHERE `email_id` = 'R'");

$stat = "Rejected";
} 

[brent5392]

Just add the column MemberApprovedDate as a timestamp.

Then add this to set the time

mysql_query("UPDATE `tblmembers` SET `MemberApprovedData`= NOW() WHERE `ID`='$id'"); 

[tomyknoker]

Can I just add that directly under my first SQL Query?

[tomyknoker]

Also can I add it as a DATE? I have everything set as DATE in my columns so it will just be easier, will i need to change that Query?

[spikeZ]

you can add it into the first query....

mysql_query("UPDATE `tblmembers` SET `MemberApproved`='$status',  `MemberApprovedData`= NOW() WHERE `ID`='$id'"); 

[spikeZ]

Also can I add it as a DATE? I have everything set as DATE in my columns so it will just be easier, will i need to change that Query?

NOW() adds a timestamp or datestamp depending on your column definition

[Raju Gautam]

Create your field MemberApprovedData with the data type datetime in mysql if you are going to use NOW() function to insert the date.

[brent5392]

Also can I add it as a DATE? I have everything set as DATE in my columns so it will just be easier, will i need to change that Query?

A timestamp is just another way of recording time. You can still fetch it, and format it, the same way as you can storing it with DATE.

Also, my mistake, I seem to have made a typo in the naming of the date field. I typed 'MemberApprovedData' instead of 'MemberApprovedDate'