Re: [PHP] php with mysql COUNT, DISTINCT syntax, might be a bit 0T

2004-02-09 Thread Ryan A
ROTECTED]> > Sent: Monday, February 09, 2004 8:36 PM > Subject: [PHP] php with mysql COUNT, DISTINCT syntax, might be a bit 0T > > > > Hi, > > I have a table where a users details are entered for the products he > bought, > > the only part that is repeated is the or

Re: [PHP] php with mysql COUNT, DISTINCT syntax, might be a bit 0T

2004-02-09 Thread Shaunak Kashyap
ject: [PHP] php with mysql COUNT, DISTINCT syntax, might be a bit 0T > Hi, > I have a table where a users details are entered for the products he bought, > the only part that is repeated is the order_id, > I basically need to only get the order per person, and paginate for all the >

[PHP] php with mysql COUNT, DISTINCT syntax, might be a bit 0T

2004-02-09 Thread Ryan A
Hi, I have a table where a users details are entered for the products he bought, the only part that is repeated is the order_id, I basically need to only get the order per person, and paginate for all the customers eg: if user "tom" bought 3 items in the database it would be entered as: order_id