I want to track when certain data points change in a record.

PHP Code:

    $sql_begin=$sql_begin.', edate, flag_edate';
    $sql_end=$sql_end.', "'.($value->edate).'" ,'.$_SERVER['REQUEST_TIME']; 


Error message

Fatal error: Function name must be a string in C:\Program Files\EasyPHP 3.0\www\My Websites\Fat Cat\parse_md4c6.php on line 235

Am I using the correct function here. i also tried getdate() but did not work. I am just trying to return the system date so that I can indicate which bits of record have changed since last reviewed.

http://dev.mysql.com/doc/refman/5.0/en/timestamp.html

The error isn't in the code you posted. The only time I've seen this error is when someone mistakenly uses parens instead of brackets to index an array. For example:

PHP Code:

$foo('bar');
$_SESSION('x');

//should be

$foo['bar'];
$_SESSION['x']; 


Okay, got it to work

Thanks for your help.

Here is the working bit of code:

PHP Code:

   else{
    $sql_begin='INSERT INTO tbl_module (project_id, module, module_desc, status, qty';
    $sql_end='VALUES ( '.$project_id.', "'.
         $value->part.'", "'.
         $value->part_desc.'", "'.
         $value->status.'", '.
         $value->qty; 
    if(!empty($value->prod)){
     $sql_begin.=', prod, flag_prod';
     $sql_end.=', "'.($value->prod).'" , Now()';