Array issue with a SQL query

Question

I have an issue with syntax in a query

This works

$db->execute_query("UPDATE table SET order=2,active_status=3 WHERE id=? AND uid=?",array($id,$uid));

But this does not. It's because of the array

$db->execute_query("UPDATE table SET order=?,active_status=3 WHERE id=? AND uid=?",array($shoid,$id,$uid));

I also tried something like

$db->execute_query("UPDATE table (`order`) WHERE id=? AND uid=? VALUES (?)",array($id,$uid,$shoid));

But this is not working either.

The error I get is this

Query failed : UPDATE orsil_quote (`order`) WHERE id='38' AND uid='115' VALUES ('49')

The problem is '49' if i can remove ' from 49 in the query. this will work like this , im sure

$db->execute_query("UPDATE table SET order=?,active_status=3 WHERE id=? AND uid=?",array($shoid,$id,$uid));

it is a lot of code, and most of it useless, if you want to know what does $shoid has, its just like $shoid='40' (the last id) i will edit to paste the error, throw so you can see — Moncho Chavez
– Moncho Chavez, Commented Jan 9, 2014 at 6:19
thanks :) that was what i meant (sorry for the sort comentary, i was on the mobile) — Melon
– Melon, Commented Jan 9, 2014 at 7:05

Deepika Janiyani · Accepted Answer · 2014-01-09 06:25:07Z

1

Your second query didn't worked because of the order keyword rest queries are not correct, like update query doesn't take VALUES i.e. used in your third query.

TRY

 db->execute_query("UPDATE table SET `order`=?,active_status=3 WHERE id=? AND  
                   uid=?",array($shoid,$id,$uid))

answered Jan 9, 2014 at 6:25

Deepika Janiyani

1,4679 silver badges17 bronze badges

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

Comments

Saharsh Shah · Accepted Answer · 2014-01-09 06:18:56Z

1

Try this:

UPDATE `table` SET `order`=2,active_status=3 WHERE (id, uid) IN (?)

Generate the pairs of (id, uid) like (id1, uid1), (id1, uid2), (id2, uid3), etc... and pass it to query.

answered Jan 9, 2014 at 6:18

Saharsh Shah

29.1k9 gold badges53 silver badges85 bronze badges

2 Comments

Moncho Chavez Over a year ago

order is a variable number sent in the array as $shoid, check the question again

Saharsh Shah Over a year ago

@MonchoChavez Then you have to fire multiple query for each set of values

Collectives™ on Stack Overflow

Array issue with a SQL query

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related