I get this syntax error
Error, insert message details failed - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''hello','helloooooa','','1')' at line 2
When trying to execute this insert function
if(isset($inputArray['Submit'])){
//pass array values to local variables
if(isset($inputArray['user_id'])){$this->user_id = "".$inputArray['user_id']."";} else {$this->user_id = "NULL";}
if(isset($inputArray['subject'])){$this->subject = $inputArray['subject'];}
if(isset($inputArray['message'])){$this->message = $inputArray['message'];}
if(isset($inputArray['create_date'])){$this->create_date = $inputArray['create_date'];}
if(isset($inputArray['status'])){$this->status = $inputArray['status'];}
$sql = "INSERT INTO message (user_id,subject,message,create_date,status)
VALUES ($this->user_id,'$this->subject','$this->message','$this->create_date','$this->status')";
$result = mysql_query($sql);
return $result;
}
Could you please help me out as i can't spot where the error is in the syntax
