aebstract Posted January 9, 2010 Share Posted January 9, 2010 I don't think it will be, but what I got so far is a query to grab a few pieces of information: SELECT so.dateissued, so.num, soitem.taxableflag, soitem.totalprice, so.shiptoname FROM so JOIN soitem ON so.id = soitem.soid WHERE so.taxrate > '0' AND so.dateissued >= '12-1-09' AND so.dateissued <= '12-31-09' AND billtozip = '95334' ORDER BY so.shiptoname, so.dateissued What I'm needing to do on the results, is have a total for each unique shiptoname and have it show in the results under each shiptoname's section. For this report there happens to be 3 unique shiptonames and like 50 results. Thing is I can only run 1 query and I don't think I can control the outcome enough to do it Quote Link to comment https://forums.phpfreaks.com/topic/187826-is-this-possible-with-1-query/ Share on other sites More sharing options...
aebstract Posted January 9, 2010 Author Share Posted January 9, 2010 I think the answer is going to be more of whatever handles the query after it is ran is what needs to do it. I don't think it's going to be possible in the software I'm using, wish this was php ;( Quote Link to comment https://forums.phpfreaks.com/topic/187826-is-this-possible-with-1-query/#findComment-991698 Share on other sites More sharing options...
fenway Posted January 16, 2010 Share Posted January 16, 2010 Why can't you simply run through the result set and count yourself? Quote Link to comment https://forums.phpfreaks.com/topic/187826-is-this-possible-with-1-query/#findComment-995941 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.