Easy way to COUNT?

[brianb]

I have a SELECT that looks like this:

$sql = "SELECT D.dvdID, D.title, D.amazon ";
$sql.= "FROM Dvds D, Dvd_Eggs E ";
$sql.= "WHERE D.dvdID = E.dvdID ";
$sql.= "AND $where ";
$sql.= "ORDER BY D.title ";
$res = mysql_query($sql);
//mysql_debug($sql,$res);

Now, I'd like to throw a COUNT in there for the number of rows it retrieves for a particular dvdID...

Can I do something like:

$sql = "SELECT D.dvdID, D.title, D.amazon, COUNT(E.eggID) ";

???

Any help is appreciated!

[examancer]

you may want to try something like this

$sql = "SELECT D.dvdID, D.title, D.amazon, COUNT(*) FROM Dvds D, Dvd_Eggs E WHERE D.dvdID = E.dvdID GROUP BY D.dvdID ORDER BY D.title";

I'm not cetain on this though, because I think you might not be able to use ORDER BY with GROUP BY, but I really don't remember. Hope that helps.