Insert query with WHERE condition in mysql

Question

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 !

Insert statements have no where clause. What are you trying to do? — Joni
– Joni, Commented May 26, 2016 at 7:35
You can't use a WHERE condition in an INSERT query. So either remove the WHERE part or change to UPDATE. — GreyRoofPigeon
– GreyRoofPigeon, Commented May 26, 2016 at 7:35

Community · Accepted Answer · 2017-05-23 12:07:56Z

2

You can't use INSERT.....WHERE, For Updating a row you need UPDATE....WHERE.

If you have the condition that you need to insert and if the key isn't exist then use the given example.

Demo for example:

INSERT INTO Users (id, weight, desiredWeight) VALUES(1, 160, 145) ON DUPLICATE KEY UPDATE weight=160, desiredWeight=145

Collected from: MySQL Insert Where query

edited May 23, 2017 at 12:07

CommunityBot

11 silver badge

answered May 26, 2016 at 7:39

Murad Hasan

9,5932 gold badges23 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Webeng · Accepted Answer · 2016-05-26 07:49:42Z

1

IMPORTANT WARNING: mysql_query was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include mysqli_query() and PDO::query()

FOR EDUCATIONAL PURPOSES: this is how your code should look if you are using mysql_query:

//you should definitely create a function that sanitizes the users input
//so that you don't get hacked via sql injection:
$value = sanitize($value);
$id= sanitize($id);

$sql = "UPDATE employee SET annual_additional = '$value' 
WHERE emp_id='$id'";
if (!result = mysql_query($sql))
{
    die("query error".mysql_error());
}

answered May 26, 2016 at 7:49

Webeng

7,0984 gold badges37 silver badges61 bronze badges

2 Comments

Chathurika Over a year ago

Definitely, now I have fixed my problem by this way, thank u

Webeng Over a year ago

@Chathurika awesome no problem! Oh and if this answer is the one that worked for you, please accept it (with a green checkmark) so that users know it worked for you :)

Max Mayerhofer · Accepted Answer · 2016-05-26 07:38:53Z

1

with witch query you get the error?Insert? Futhermore, use mysql_real_escape_string or this: http://pear.php.net/package/DB for your querys.

answered May 26, 2016 at 7:38

Max Mayerhofer

113 bronze badges

Comments

Sunil Rajput · Accepted Answer · 2016-05-26 10:46:13Z

1

You Should Use 'UPDATE' instead of 'INSERT'

UPDATE employee SET `annual_additional`='$value' WHERE `emp_id`='$id'

Hope It will Work.

answered May 26, 2016 at 10:46

Sunil Rajput

9909 silver badges19 bronze badges

Collectives™ on Stack Overflow

Insert query with WHERE condition in mysql

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related