tauchai83 Posted February 8, 2007 Share Posted February 8, 2007 Hi all, I have one table that contain 2 primary key, pd_id and od_id and additional column od_qty (order quantity). i'm trying to do a query that can retrive the total of the order quantity for each product. here is my code: $total = mysql_query("SELECT pd_id, SUM(od_qty) AS cnt FROM order_item WHERE pd_id=$pd_id "); it returns Resource id #4 which i Don't know what does it means. Can anyone help me? thanks a lot! -chai- Link to comment https://forums.phpfreaks.com/topic/37608-solved-help/ Share on other sites More sharing options...
tauchai83 Posted February 8, 2007 Author Share Posted February 8, 2007 ignore this...i guess i know waht went wrong...haha..sori Link to comment https://forums.phpfreaks.com/topic/37608-solved-help/#findComment-179839 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.