I tried to insert data into mysql table with some where condition. But it makes some error which is
error on queryYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE
I have tried following query,
if(isset($_POST['submit'])){
$type=$_POST['leave_type'];
$division=$_POST['division'];
$number_of_date=$_POST['number_of_date'];
$resul=mysql_query("SELECT * from employee where (division='$division' || division='all_dpt')") or die("query error".mysql_error());
$result3 = mysql_fetch_array($resul);
$emp_division=$result3['division'];
$id=$result3['emp_id'];
$annual_additional=$result3['annual_additional'];
$value=$annual_additional+$number_of_date;
if(($division==$emp_division || $division='all_dpt') && $type='Annual'){
$result1=mysql_query("INSERT INTO employee (annual_additional) VALUES ('$value') WHERE emp_id='$id'")or die("error on query".mysql_error());
}}
How can I fix it, please help !