Cannot get PHP to execute MySQL query

Question

Why doesn't my MySQL code work from PHP. However if I return the SQL and paste it into the SQL console the rows update accordingly.

SQL

UPDATE propertypriority 
   SET prioritylevel = '8' 
 WHERE roomtypecode = '1184'; 

UPDATE property 
   SET prioritylevel = '8' 
 WHERE roomtypecode = '1184';

PHP

$sql = "UPDATE propertypriority 
           SET prioritylevel = '".$demotionvalue."' 
         WHERE roomtypecode = '".$row['roomtypecode']."'; "
       ."UPDATE property
            SET prioritylevel = '".$demotionvalue."' 
          WHERE roomtypecode = '".$row['roomtypecode']."'; ";

im a noob and im trying to work out how to cascade on update? — JS1986
– JS1986, Commented Apr 2, 2011 at 3:10

Robot Woods · Accepted Answer · 2011-04-02 03:03:50Z

3

from: http://www.tutorialspoint.com/mysql/mysql-sql-injection.htm

'Fortunately, if you use MySQL, the mysql_query() function does not permit query stacking, or executing multiple queries in a single function call. If you try to stack queries, the call fails.'

so maybe try breaking it into two queries

answered Apr 2, 2011 at 3:03

Robot Woods

5,6872 gold badges24 silver badges30 bronze badges

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

Comments

Erik · Accepted Answer · 2011-04-02 03:15:12Z

1

I think you might want to look into wrapping your SQL statements into a transaction.

This page from the manual has a example for you.

answered Apr 2, 2011 at 3:15

Erik

4462 silver badges5 bronze badges

Comments

Dave · Accepted Answer · 2011-04-02 03:01:21Z

0

Are you using mysqli? If so, depending on how you execute the query, it's not going to allow you to execute two statements with one command.

answered Apr 2, 2011 at 3:01

Dave

7976 silver badges10 bronze badges

1 Comment

rockerest Over a year ago

I definitely think that including ";" in a SQL command is the problem. Most definitely.

Collectives™ on Stack Overflow

Cannot get PHP to execute MySQL query

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related