tomliuwhite Posted March 1, 2006 Share Posted March 1, 2006 I have installed one contribution called "customers_extra_fields" and used it to add a new field called "team code" to account information. Now i want to search the database to calculate TOTAL PURCHASES PER TEAM CODE PER MONTH. What shall i do? Many thanks in advance. Link to comment Share on other sites More sharing options...
Guest Posted March 1, 2006 Share Posted March 1, 2006 you could use a store statistics contribution. See how it works and customize it for your custom fields. http://www.oscommerce.com/community/contributions,3738 Link to comment Share on other sites More sharing options...
tomliuwhite Posted March 2, 2006 Author Share Posted March 2, 2006 you could use a store statistics contribution. See how it works and customize it for your custom fields.http://www.oscommerce.com/community/contributions,3738 Thanks for your help. I have installed the contribution. But i think this contribution is not the one i want and it is a little difficult to cusomize to fit my need. Can i just use phpmyadmin to go to database to run some command to get the result? Thans a lot. Link to comment Share on other sites More sharing options...
Guest Posted March 2, 2006 Share Posted March 2, 2006 you could, by running a bunch of scripts but would be much easier to set it up with the osc admin. And have the results with the click of a button everytime you need it. Of course it requires some work. Link to comment Share on other sites More sharing options...
tomliuwhite Posted March 2, 2006 Author Share Posted March 2, 2006 you could, by running a bunch of scripts but would be much easier to set it up with the osc admin. And have the results with the click of a button everytime you need it. Of course it requires some work. Yes. But it is an urgent thing. I do not have much time to work on that. So for now I just want to run scripts to get result manually. Can you help me to how to write the scripts? And I think I can use phpmyadmin to go to database to run some SQL scripts. But I do not know how to write such SQL scripts. Can you help me? Thanks a lot. Link to comment Share on other sites More sharing options...
Guest Posted March 2, 2006 Share Posted March 2, 2006 you would have to post your scripts that use the TEAM CODES and any other custom tables you're taking into account for the average, so someone from the forum may be able to answer. But it will be more complicated going down that path. Would be faster to just mod the contribution for this purpose. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.