Jump to content

Archived

This topic is now archived and is closed to further replies.

crazylegseddie

What can I use instead??

Recommended Posts

Hi everyone. I followed a tutorial script to complete a shopping basket site. Currently the script uses UNION to combine the queries but  I just realised the server I am using uses an older version of mySQL that does not support the UNION function, so can anyone help me out and tell me what I can use as a replacement?? Heres the script:

[code=php:0]
function getOrderAmount($orderId)
{
$orderAmount = 0;

$sql = "SELECT SUM(pd_price * od_qty)
        FROM tbl_order_item oi, tbl_product p
    WHERE oi.pd_id = p.pd_id and oi.od_id = $orderId

UNION

SELECT od_shipping_cost
FROM tbl_order
WHERE od_id = $orderId";


$result = dbQuery($sql);

if (dbNumRows($result) == 2) {
$row = dbFetchRow($result);
$totalPurchase = $row[0];

$row = dbFetchRow($result);
$shippingCost = $row[0];

$orderAmount = $totalPurchase + $shippingCost;
}

return $orderAmount;
}

?>
[/code]

any response will be greatly appreciated :)

Share this post


Link to post
Share on other sites
Just run them separately, and combine them in PHP.

Share this post


Link to post
Share on other sites
I tried:
[code=php:0]
$sql = "SELECT SUM(pd_price * od_qty)
        FROM tbl_order_item oi, tbl_product p
    WHERE oi.pd_id = p.pd_id and oi.od_id = $orderId";

$result = dbQuery($sql);

$sql2 = "SELECT od_shipping_cost
FROM tbl_order
WHERE od_id = $orderId";
$result = dbQuery($sql2);
[/code]

but no matter what i add to my cart this gave me a total of 0 when I processed the ammount in paypal? Is this because Im not combining the two queries with PHP? If not how can I do that?  ???

Share this post


Link to post
Share on other sites
Well, you'll need to iterate though each result set separately, then store the results elsewhere.  Unfortunately, I know absolutely nothing about PHP, so I can't tell you how to do it other than to describe the pseudo-code.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.