Help with a query

[graham23s]

Hi GUys,

 

i'm using this query to get the sum total from a table:

 

<?php
$q_price = "SELECT SUM(quantity_total) as `total` FROM `fcp_orders` WHERE `customer_id`='$var_loggedinuserid'";
$r_price = mysql_query($q_price);
?>

 

i also need the `shipping_costs` values from this table aswell, do i need to do another query or can i get the row by adding to the query above?

 

thanks guys

 

Graham

[benjaminbeazy]

you should be able to just tack on shipping_costs to you select..

[Barand]

try it

<?php

$q_price = "SELECT SUM(quantity_total) as `total`, SUM(shipping_costs) as totship FROM `fcp_orders` WHERE `customer_id`='$var_loggedinuserid'";

[graham23s]

Hi GUys,

 

i did this:

 

 $q_price = "SELECT shipping_costs, SUM(quantity_total) as `total` FROM `fcp_orders` WHERE `customer_id`='$var_loggedinuserid'";
$r_price = mysql_query($q_price); 

 

just to get the results once from the table, i just need to get the shipping costs once, then i can work with it from there but i am getting a "mysql_fetch_array(): supplied argument is not a valid MySQL result resource " with the query i did above i thought the syntax looked ok am i wrong?

 

thanks guys

 

Graham

[Barand]

You can aggregate or select individual row values but not both in a simple SELECT.

 

This will give rows with individual shipping_costs and also the total quantity in every row

 

SELECT shipping_costs

FROM `fcp_orders`

JOIN (SELECT SUM(quantity_total) as `total` FROM `fcp_orders` WHERE `customer_id`='$var_loggedinuserid') as qtotal

WHERE `customer_id`='$var_loggedinuserid'