* 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 sku
Curt
--
First, let me assure you that this is not one of those shady pyramid schemes
you've been hearing about. No, sir. Our model is the trapezoid!
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
