mysql - I'm getting a syntax error on a mysqli query -


    $updatevehicle=mysqli_query($con, "insert `vehicles` (make,model,plate_no)". "values ('$make', '$model', '$plate') `customerid` = '$customerid'")or die(mysqli_error($con)); 

this error message: you have error in sql syntax; check manual corresponds mysql server version right syntax use near 'where customerid = 12369' @ line 1

i've verified table exists , rows specified type case sensitive match database.

thank help

please review query should update query not insert query.


Comments

Popular posts from this blog

java - Intellij Synchronizing output directories .. -

git - Initial Commit: "fatal: could not create leading directories of ..." -