I get an error with my PHP code updating one table

Question

I get an error with my PHP code when updating the table patient. I cannot find the problem.

Here is my error:

Verification Error: 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 '1' at line 1

<?php
$edit = mysql_query("UPDATE `patient` SET `date`='$date', `fname`='$fname', `lname`='$lname', `birthday`='$dob', `address`='$address', `work`='$work', `civil`='$civil', `gender`='$sex', `btype`='$bloodtype', `height`='$hgt', `weight`='$wgt', `fallergy`='$fallergy', `mallergy`='$mallergy' WHERE `patientid`='$vara'");
$result = mysql_query($edit) or die("Verification Error: " . mysql_error());

$edit = mysql_query("UPDATE patient SET date='$date', fname='$fname', lname='$lname', birthday='$dob', address='$address', work='$work', civil='$civil', gender='$sex', btype='$bloodtype', height='$hgt', weight='$wgt', fallergy='$fallergy', mallergy='$mallergy' WHERE patientid='$vara'"); $result = mysql_query($edit) or die("Verification Error: " . mysql_error()); — EverythingRichardify
– EverythingRichardify, Commented Mar 1, 2015 at 5:34
use echo $edit; after your query in $edit .And copy paste the query string in Database, phpmyadmin. And tell us what is error. — Pratik Joshi
– Pratik Joshi, Commented Mar 1, 2015 at 5:36
Next time you create a question or answer, please put more effort into it. We should not have to clean up after you. — Sverri M. Olsen
– Sverri M. Olsen, Commented Mar 1, 2015 at 5:39
@EverythingRichardify , hi , I asked : use echo $edit; after your query in $edit .And copy paste the query string in Database, phpmyadmin. And tell us what is error. — Pratik Joshi
– Pratik Joshi, Commented Mar 1, 2015 at 5:42

Sverri M. Olsen · Accepted Answer · 2015-03-01 05:44:55Z

2

You are calling mysql_query twice; the second time you pass the result, of the first call, into it as an argument. That is not how mysql_query works. The SQL should just be a string:

$edit = "UPDATE `patient` SET `date`='$date', `fname` ...";
$result = mysql_query($edit) or die("Verification Error: " . mysql_error());

We cannot see the rest of your code, so we do not know if there are more problems, but this should fix the problem in your question.

answered Mar 1, 2015 at 5:44

Sverri M. Olsen

13.2k3 gold badges38 silver badges54 bronze badges

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

Collectives™ on Stack Overflow

I get an error with my PHP code updating one table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related