Re: [PHP] COUNT(*) Output Question

2004-08-02 Thread Tom Ray [Lists]
Thanks JohnI didn't think of thatI've been working on this catalog admin interface for to long..my brain is mush. John W. Holmes wrote: From: "Tom Ray [Lists]" <[EMAIL PROTECTED]> $count=mysql_query("SELECT sku, COUNT(*) FROM orders GROUP BY sku"); But my question is how do I use P

Re: [PHP] COUNT(*) Output Question

2004-08-02 Thread John W. Holmes
From: "Tom Ray [Lists]" <[EMAIL PROTECTED]> > $count=mysql_query("SELECT sku, COUNT(*) FROM orders GROUP BY sku"); > > But my question is how do I use PHP to output the COUNT(*) results? When > I run the command when I'm logged into mySQL I get the following: I assume you're fetching associative

Re: [PHP] COUNT(*) Output Question

2004-08-02 Thread Curt Zirzow
* Thus wrote Tom Ray [Lists]: > Hey- > > I'm query my mySQL database to see how many of each Sku has been > ordered. I am doing my query as: > > $count=mysql_query("SELECT sku, COUNT(*) FROM orders GROUP BY sku"); alias the count(*) column: SELECT sku, COUNT(*) as qty FROM orders GROUP BY s

RE: [PHP] COUNT(*) Output Question

2004-08-02 Thread Brad Ciszewski
Wouldn't count(sku) work? -Original Message- From: Tom Ray [Lists] [mailto:[EMAIL PROTECTED] Sent: Monday, August 02, 2004 3:20 PM To: [EMAIL PROTECTED] Subject: [PHP] COUNT(*) Output Question Hey- I'm query my mySQL database to see how many of each Sku has been ordered. I am doing my