budimir Posted January 10, 2015 Share Posted January 10, 2015 Guys, What is wrong in this query? It's throwing an error. $upit = "SELECT Br_artikla, Prodana_kolicina, Godina FROM katalog_pribora_povijest WHERE Br_artikla = " . implode(' OR Br_artikla = ', $kataloski) . " GROUP BY Godina"; Error I get: 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 '02 83-01 OR Br_artikla = 503 86 27-02 OR Br_artikla = 503 86 27-03 OR Br_artikla' at line 3 Quote Link to comment https://forums.phpfreaks.com/topic/293809-implode-in-mysql/ Share on other sites More sharing options...
Solution budimir Posted January 10, 2015 Author Solution Share Posted January 10, 2015 Ok, I found a soltuion to my problem. $upit = "SELECT Br_artikla, Prodana_kolicina, Godina FROM katalog_pribora_povijest WHERE Br_artikla IN ('".implode("','", $kataloski)."') GROUP BY Godina"; Quote Link to comment https://forums.phpfreaks.com/topic/293809-implode-in-mysql/#findComment-1502411 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.