I cannot seem to get a SELECT COUNT for a query from fields in two different tables and a WHERE clause. Does anyone know if this is not possible with php/mysql or am I doing something wrong? I have tried a number of variations on the following code:
$sql = "SELECT COUNT(*), bandid, bandname, genre
FROM bands, genre
WHERE genre.genreid=$g
AND bands.genreid=genre.genreid
ORDER BY bandname ASC";
$gen = mysql_fetch_row(mysql_query($sql)); echo $gen[0];
I know from documentation that COUNT works with WHERE clauses...but also from two tables?
There's no reason it shouldn't work. The best way to troubleshoot these things is to get the query working without the COUNT(*) and make sure it's returning the right number of rows.
Are you even sure the query is executing? Maybe it's failing...
$result = mysql_query($sql) or die(mysql_error()); $gen = mysql_fetch_row($result);
-- ---John Holmes...
Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/
php|architect: The Magazine for PHP Professionals – www.phparch.com
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
