Доброго времени суток!
Помогите разобраться пожалуйста!
При выполнения запроса к базе выдает ошибку:
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in Z:\home\qwerry.ru\www\models\shopping_cart_model.php on line 145

Ругается на строчку
$row = mysql_fetch_assoc($this->res)

А вот сам запрос:

$res = mysqlQuery("SELECT
qwerry_shopping_cart.item_id,
qwerry_production.name,
COALESCE(NULLIF(qwerry_production.discounted_price,0),
qwerry_production.price) AS price,
qwerry_shopping_cart.quantity,
COALESCE(NULLIF(qwerry_production.discounted_price,0),
qwerry_production.price)*qwerry_shopping_cart.quantity AS subtotal
FROM `qwerry_shopping_cart`
INNER JOIN `qwerry_production`
ON qwerry_shopping_cart.product_id = qwerry_production.id
WHERE qwerry_shopping_cart.cart_id = '".$inCartId."' AND qwerry_shopping_cart.buy_now = 1"
);

Что я делаю не так?

Zaur делай проверку что в переменной $this->res, видимо ты туда передаешь false

Спасибо, а можно ли как-то увидеть то, что я передаю в $res?

$sql = "SELECT 
qwerry_shopping_cart.item_id, 
qwerry_production.name, 
COALESCE(NULLIF(qwerry_production.discounted_price,0),
qwerry_production.price) AS price,
qwerry_shopping_cart.quantity,
COALESCE(NULLIF(qwerry_production.discounted_price,0),
qwerry_production.price)*qwerry_shopping_cart.quantity AS subtotal
FROM `qwerry_shopping_cart` 
INNER JOIN `qwerry_production`
ON qwerry_shopping_cart.product_id = qwerry_production.id
WHERE qwerry_shopping_cart.cart_id = '".$inCartId."' AND qwerry_shopping_cart.buy_now = 1";

echo "<br>$sql<br>";

Вот, выводит следующее

SELECT qwerry_shopping_cart.item_id, qwerry_production.name, COALESCE(NULLIF(qwerry_production.discounted_price,0), qwerry_production.price) AS price, qwerry_shopping_cart.quantity, COALESCE(NULLIF(qwerry_production.discounted_price,0), qwerry_production.price)*qwerry_shopping_cart.quantity AS subtotal FROM `qwerry_shopping_cart` INNER JOIN `qwerry_production` ON qwerry_shopping_cart.product_id = qwerry_production.id WHERE qwerry_shopping_cart.cart_id = '54da2013cb2463de4326bd9ba4b01f5e' AND qwerry_shopping_cart.buy_now = 1

Кстати проверил то, что в $res добавив в конце вывод в цикле

$res = mysqlQuery("SELECT
qwerry_shopping_cart.item_id,
qwerry_production.name,
COALESCE(NULLIF(qwerry_production.discounted_price,0),
qwerry_production.price) AS price,
qwerry_shopping_cart.quantity,
COALESCE(NULLIF(qwerry_production.discounted_price,0),
qwerry_production.price)*qwerry_shopping_cart.quantity AS subtotal
FROM `qwerry_shopping_cart`
INNER JOIN `qwerry_production`
ON qwerry_shopping_cart.product_id = qwerry_production.id
WHERE qwerry_shopping_cart.cart_id = '".$inCartId."' AND qwerry_shopping_cart.buy_now = 1"
);
while($a = mysql_fetch_array($res))
{
echo $a[0].$a[1].$a['name']."<br>";
}


и вывело значения из базы как и нужно, выходит в $res находится нужное, откуда же тогда ошибка не пойму