Stack Overflow на русском Asked on December 9, 2021
может кто сталкивался?
$prod_get_attr = "SELECT oca.product_id, pr.price, pr.image, pd.name
FROM oc_product_attribute AS oca LEFT JOIN oc_product AS pr ON pr.product_id = oca.product_id
LEFT JOIN oc_product_description AS pd ON pd.product_id = oca.product_id
WHERE text IN ('" . $get_material_item . "') AND oca.product_id IN (SELECT oca2.product_id FROM oc_product_attribute AS oca2
WHERE text IN ('" . $get_ves_item . "')) GROUP BY oca.product_id";
$query_prod_get_attr = mysqli_query($dbh, $prod_get_attr);
var_dump($query_prod_get_attr);
Данный скрипт работает в pma если ввести значения вручную (не переменными), переношу в скрипт и получаю не массив значений а bool(false), подскажите пожалуйста, в чем ошибка?
Попробуй так WHERE text IN ({$get_material_item}) AND oca.product_id IN (SELECT oca2.product_id FROM oc_product_attribute AS oca2 WHERE text IN ({$get_ves_item})) GROUP BY oca.product_id";
Answered by pwnz on December 9, 2021
Get help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP