So i have an SQL query, that looks like this and when executing I get no value for my result and no change in my database. Whats the problem here?
$result = $db->query("UPDATE product SET price=$price WHERE id=0x$data[0]");
print_r($result);
Asked
Active
Viewed 24 times
0
Grimclaw Draven
- 155
- 9
-
can you please print `$price` and `0x$data[0]` and share here? and print `$db` as well – Monish Khatri Jun 16 '22 at 10:34
-
$result = $db->query("UPDATE product SET price='$price' WHERE id=0x$data[0]"); Solved the problem using '' – Grimclaw Draven Jun 16 '22 at 11:52
-
Please consider using the repositories of shopware. This way all the events will be triggered for other extensions. – LastSgt Jul 05 '22 at 05:25