System date and time

[taz321]

Hi

i was wondering if i can some help on somethings basic and hopefully very quick

 

This is the scenario.

 

1)I have developed an help desk system, where an user would log a call by filling in an online blank form, this contains the date and time when the user had submitted the query.

 

2) An person dealing with the problem would open the call and add his own technical comments and then save it to the database (he updates the call basically)

 

EASY so far - i hope.

 

 

Now this is the code for updating, i just want to know how i would change the end two entites - (dateactioned and timeactioned) so that it would save the current date and time.

 

 

$query = "update form set issuetitle = ".$issuetitle."', datesubmitted = ".$datesubmitted."', timesubmitted ='".$timesubmitted."', systemaffected ='".$systemaffected."', prioritylevel = '".$prioritylevel."', issuedetails ='".$issuedetails."', supportcomments ='".$supportcomments."', clientFname ='".$clientFname."', clientSurname ='".$clientSurname."', teamname ='".$teamname."', clientID ='".$clientID."', employeeID ='".$employeeID."', status ='".$status."', dateactioned ='".$dateactioned."', timeactioned ='".$timeactioned."' where formID =".$formID;

 

 

I hope this is straightfoward.

 

Thanks

 

 

 

 

[BlueSkyIS]

dateactioned = NOW()