[eluser]extra_rice[/eluser]
the trans_datetime doesn't return the current date...
Code:
$data = array(
'username' => $username,
'lastname' => $lastname,
'firstname' => $firstname,
'middlename' => $middlename,
'status' => 0,
'pass_attr' => 0,
'password' => $password,
'landline_number' => $landlineNumber,
'mobile_number' => $mobileNumber,
'email' => $email,
'trans_datetime' => 'sysdate()',
'trans_user' => 0
);
$this->obj->db->insert($this->table, $data);
and this one without the single quote gives a PHP error...
Code:
$data = array(
'username' => $username,
'lastname' => $lastname,
'firstname' => $firstname,
'middlename' => $middlename,
'status' => 0,
'pass_attr' => 0,
'password' => $password,
'landline_number' => $landlineNumber,
'mobile_number' => $mobileNumber,
'email' => $email,
'trans_datetime' => sysdate(),
'trans_user' => 0
);
$this->obj->db->insert($this->table, $data);
any solutions guys?