Jump to content

MySql export issue


JadedLucidity

Recommended Posts

I'm hoping someone can help me with this.

 

I have a table with three columns

 

1 - auto indexed number

2 - product number (repeats depending on date)

3 - date

 

so product 123 was sold  on January 1, 2005, 8:30 AM and again on January 1, 2006, 9:15 PM etc etc etc. Lots of duplicates

 

How do I query to just say product 123 had 15 sales between January 1, 2005 and January 1, 2006. Is there a way just to count how many between two dates and then export this report directly to excel?

 

So it would be:

 

Product id              Number of sales

123                        15

124                        12

 

Something like that. Are there any tutorials on this?

 

Thanks

 

Link to comment
https://forums.phpfreaks.com/topic/37550-mysql-export-issue/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.