Nested MySQL statement issues: "Unable to save result set" error.

HI all,

tableA record contains two foreign record key references to tableB.

I'd like to select itemR1, priceR1, itemR2, priceR2 FROM tableB.

However, i keep getting the "Unable to save result set" error.

This is the code segment:

<?php

$sql = 'SELECT ip.SVID, ip.ITID, ip.Item AS ItemA, ip.Price AS PriceA, it.itQTY AS QtyA,
(SELECT ip.Item
FROM `it-pricelist` AS ip
INNER JOIN `items` AS it ON it.AIID = ip.ITID
WHERE it.WOID = '.$row[0].') AS ItemB,
(SELECT ip.Price
FROM `it-pricelist` AS ip
INNER JOIN `items` AS it ON it.AIID = ip.ITID
WHERE it.WOID = '.$row[0].') AS PriceB,
it.aiQTY AS QtyB';
$sql .= ' FROM `it-pricelist` AS ip';
$sql .= ' INNER JOIN `items` AS it ON it.ITID = ip.ITID';
$sql .= ' WHERE it.WOID = '.$row[0]; // $row[0] contains the ID of the workorder record queried in the previous select.

$sql .= ' ORDER BY ip.ITID';

?>

Removing the nested select's removes the error but does not give me all the data i need.

In any case, I can't see my error. Can anyone help?

thanks,

Nested MySQL statement issues: "Unable to save result set" error.

nelsonm

Dijkgraaf

nelsonm

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week