Parse error while combining multiple query statement

Question

I wrote a php code to replace SQL row values. But it is not working as expected

ERROR : Parse error: syntax error, unexpected T_STRING in ...... on line 3

I think i should not use these quotes " " right ? But, when i ran this without " " got this error

Error updating comment table: 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

Here is my Code

<?php    
include_once("db.php");    
$sql1 = "update table1 set marks = replace(c2,"NK",'NOKIA')";
$sql2 = "update table1 set marks = replace(c2,"SM",'SAMSUNG')";
$sql3 = "update table1 set marks = replace(c2,"A",'APPLE')";
$sql4 = "update table1 set marks = replace(c2,"CH",'CHINAPECE')";
$sql5 = "update table1 set marks = replace(c2,"WO",'WORLDCLASS')";
if (mysql_query($sql1 && $sql2 && $sql3 && $sql4 && $sql5))
  {
  echo "Replaced.";
  }
else
  {
  echo "Error in replacing: " . mysql_error();
  }
?>

Thank you!

UPDATE (updated php code with sujjestions sugested by Trinimon and beiller)

ERROR : Parse error: syntax error, unexpected ';' in .... on line 8

<?php    
    include_once("db.php");
    $sql1 = "update table1 set marks = replace(c2,"NK",'NOKIA')";
    $sql2 = "update table1 set marks = replace(c2,"SM",'SAMSUNG')";
    $sql3 = "update table1 set marks = replace(c2,"A",'APPLE')";
    $sql4 = "update table1 set marks = replace(c2,"CH",'CHINAPECE')";
    $sql5 = "update table1 set marks = replace(c2,"WO",'WORLDCLASS')";
    if (mysql_query($sql1);
        mysql_query($sql2);
        mysql_query($sql3);
        mysql_query($sql4);
        mysql_query($sql5);)
  {
      echo "Replaced.";
      }
    else
      {
      echo "Error in replacing: " . mysql_error();
      }
    ?>

ERROR : Parse error: syntax error, unexpected ';' in .... on line 8

Quotes, quotes, quotes. A basic syntax highlighter will catch this for you. — John Conde, May 16 '13 at 19:00
possible duplicate of [Escaping quotation marks in PHP](http://stackoverflow.com/questions/7999148/escaping-quotation-marks-in-php) — qJake, May 16 '13 at 19:03
I misunderstood the question, my answer is deleted now. Look at the other one, he's right. Just remember that '\' is an escape character for these kinda of things. If you need to actually use '|' you should use '\\' which will result in only one backslash. — , May 16 '13 at 19:06
@PeeHaa埽, Such mistakes are very abundant, if it can be addressed in more than one way, isn't that something good? — Starx, May 16 '13 at 19:41
@Starx I disagree. Parse error questions are not helpful, except for the one posting the question. The goal of Stackoverflow questions is to help future visitors. — Jocelyn, May 16 '13 at 19:42
@Jocelyn, Look at your right side, I know what you mean. So many questions like this, but parse error are also error in programming So I believe it is a valid question. — Starx, May 16 '13 at 19:47

beiller · Answer 1 · 2013-05-16T20:02:09.097

3

 mysql_query($sql1 && $sql2 && $sql3 && $sql4 && $sql5);

This is incorrect. One mysql_query per $sql.

mysql_query($sql1);
mysql_query($sql2);
mysql_query($sql3);
mysql_query($sql4);
mysql_query($sql5);

As your error message shows $sql1 && $sql2 == TRUE which turns into "1" which is an invalid query.

edited May 16 '13 at 20:02

answered May 16 '13 at 19:08

beiller

3,105
1
11
19

when i did this. got this error > `Parse error: syntax error, unexpected ';' in ........ on line 8` it is exatly the line it starts `mysql_query($sql1);` – user2373405 May 16 '13 at 19:17
bro i have updated my question, please check it ones – user2373405 May 16 '13 at 19:22
thanks a lot bro. bro i have updated my question, please check it ones.. still facing a error – user2373405 May 16 '13 at 19:23
+1 up for you bro :) thank you!! – user2373405 May 16 '13 at 19:38
Ah sorry, I forgot a semi-colon at the first line. Haha no correct answer for me :( – beiller May 16 '13 at 20:02
@Pyrech said this before than you :) check his answer – user2373405 May 17 '13 at 03:51

Starx · Accepted Answer · 2013-05-16T19:30:09.560

2

Your problem is due to unescaped quotes. Use Single Quotes to define the values in a query string. It is less confusing that way.

Also there is a problem with the statements. Since you are combining statements they have to terminated using delimeter ;

$sql = "update table1 set marks = replace(c2,'NK','NOKIA');";
$sql .= "update table1 set marks = replace(c2,'SM','SAMSUNG');";
$sql .= "update table1 set marks = replace(c2,'A','APPLE');";
$sql .= "update table1 set marks = replace(c2,'CH','CHINAPECE');";
$sql .= "update table1 set marks = replace(c2,'WO','WORLDCLASS');";

And query like this:

mysql_query($sql);

NOTE: Please dont use MYSQL_* API Functions they are deprecated

edited May 16 '13 at 19:30

answered May 16 '13 at 19:05

Starx

77,474
47
185
261

already tried this bro. didn't work. – user2373405 May 16 '13 at 19:09
@user2373405, Try again. I missed another problem – Starx May 16 '13 at 19:11
not woked bro, same error again > thanks for your time. but got an error > Error updating comment table: 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 – user2373405 May 16 '13 at 19:14
@user2373405, What is c2 – Starx May 16 '13 at 19:22
it is my column name. – user2373405 May 16 '13 at 19:24
@user2373405, I am changed my answer. Please try that and provide me the output of `echo $sql;` – Starx May 16 '13 at 19:30
thank you bro! solved :) +one and right answer for you :) – user2373405 May 16 '13 at 19:33

score 1 · Answer 3 · edited May 23 '17 at 12:05

1

Alternatively use this

$sql1 = "update table1 set marks = replace(c2,\"NK\",'NOKIA')";
$sql2 = "update table1 set marks = replace(c2,\"SM\",'SAMSUNG')";
$sql3 = "update table1 set marks = replace(c2,\"A\",'APPLE')";
$sql4 = "update table1 set marks = replace(c2,\"CH\",'CHINAPECE')";
$sql5 = "update table1 set marks = replace(c2,\"WO\",'WORLDCLASS')";

Se this post too.

p.s.: in addition I'm not so sure about this command:

if (mysql_query($sql1 && $sql2 && $sql3 && $sql4 && $sql5))

Check out this documentation (its deprecated and says "multiple queries are not supported"). I think you should use ...

$con=mysqli_connect("host","user","password","database");
mysqli_query($con,$sql1);
mysqli_query($con,$sql2);
...

Cheers!

edited May 23 '17 at 12:05

Community

1
1

answered May 16 '13 at 19:02

Trinimon

13,839
9
44
60

thanks for your time. but got an error >> Error updating comment table: 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 – user2373405 May 16 '13 at 19:07
I was editing while you added the comment :) please see updates ... – Trinimon May 16 '13 at 19:13
thank you bro. but still facing an error. have updated my question. check it ones – user2373405 May 16 '13 at 19:24
+1 up for you bro :) thank you! – user2373405 May 16 '13 at 19:36

score 1 · Answer 4 · answered May 16 '13 at 19:25

1

if (mysql_query($sql1);
        mysql_query($sql2);
        mysql_query($sql3);
        mysql_query($sql4);
        mysql_query($sql5);)

is wrong. You should use a logical operator between each statement like && (AND), || (OR)

answered May 16 '13 at 19:25

Pyrech

593
1
4
14

thank you but previously I'm using the same. facing error at that time too.. will retrieve my changes back and will try again. thanks – user2373405 May 16 '13 at 19:27
+1 up for you bro :) thank you!! – user2373405 May 16 '13 at 19:37

Parse error while combining multiple query statement

4 Answers4

NOTE: Please dont use MYSQL_* API Functions they are deprecated