How do I store data to allow me to generate report?

Hi,

I’m looking for some help with using PHP and MySQL. It’s more the theory than the technical stuff!

I have a client who wants to know what people are adding to their shopping cart, irrespective of if they actually buy. From this, be able to see this information over a given timescale (last week, last month, last 7 days etc).

The only way I can think to generate this information is to create a table that has fields for a date and stock number. Then, every time an item is added to the cart, I add a new row with this information. I can then extract the information when the client wants it.

My concern is that the table could, potentially, be massive!

Is there any other way to store data that would be able to generate the reports mentions?

Thanks in advance,
Danny

Also in #PHP _↴