Mark Gordon wrote:

Yes, query is definitely working without COUNT(*). Even in the most stripped down form, the query fails:

$sql = "SELECT COUNT(bandid), genre
FROM bands, genre";
while ($gen=mysql_fetch_row($result)) {
echo $gen[1];

Fails how? If it echos zero, it's not failing; your query just isn't returning any rows (regardless whether you think it should or not).

---John Holmes...

Amazon Wishlist:

php|architect: The Magazine for PHP Professionals –

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to