18
Thanks ghia!
Ok this is what I was going to try.... let me know your thoughts.. was I on the right track :)
(' SELECT qty COUNT(*) FROM ' . $xoopsDB->prefix('kshop_orders_products') . ' GROUP BY p_name ' );
This is with your code I will have to test it out later. but let me know if I am formating it correctly
function loadstats(){
global $xoopsDB,$xoopsModuleConfig;
$stat=array();
$query = $xoopsDB->query(' SELECT SUM(`qty`) as 'total_qty', `p_name` FROM ' . $xoopsDB->prefix('kshop_orders_products'). ' GROUP BY `p_num`, `p_name` ORDER BY `p_name`');
while ($row = $xoopsDB->fetchArray($query))
{
$stat['qty']=$row['qty'];
$stat['p_num']=$row['p_num'];
$stat['p_name']=$row['p_name'];
}
return $stat;
}
As for the cat and product lists that I was working on is there a better way I could do that? I was looking at the suggestion you had linked in but I was having trouble translating into what I was trying to do
I get to use my "new to php codeing" card on that one :P
Thanks for all your help
