Hey Jason, hmm ok. currently I have used only ONE recordset and with this I have been able to extract seperate calculations from this 1 recordset to include on my page statistics for:
Just to make sure we are both on the same page with my question...heres more details:
Currently...the page works with 1 recordset to display the following:
Total revenue is : £8,921.02
Total gift vouchers redeemed valued at : £90.00
Total coupons used valued at : £0.00
Total Current Orders : 128
Average Shopping basket spend :£69.70
using custom php as follows:
<?php
$query="SELECT SUM(OrderAmount) AS `total` from orders";
$result=mysql_query($query);
$total=mysql_result($result,0,"total");
?>
<?php
$query="SELECT SUM(OrderAmount) AS `atotal` from orders";
$result=mysql_query($query);
$atotal=mysql_result($result,0,"atotal");
?>
<?php
$query="SELECT SUM(OrderCoupon) AS `ctotal` from orders";
$result=mysql_query($query);
$ctotal=mysql_result($result,0,"ctotal");
?>
<?php
$query="SELECT SUM(OrderVoucher) AS `vtotal` from orders";
$result=mysql_query($query);
$vtotal=mysql_result($result,0,"vtotal");
?>
therefore I was hoping I could use the same method to create a query for what I wanted.
for example of the page it will show:
Total order revenue for current month : £1432.54
Total order revenue by month : August (this would be a link)
Total order revenue by tax year : 2013 (this would be a link)
Popular month for transactions : November
Popular day for transactions : Thursday
Popular product : Ball Bracelet
Popular category : Bracelets
Popular country : United Kingdom
Popular delivery method : Recorded Delivery
Couldnt I just use the same method with the PHP i included above to create the calculation into the php tags and then assign a variable to that query?
Chris
