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";
$result=mysql_query($sql);
while ($gen=mysql_fetch_row($result)) {
echo $gen[1];
}
 

"John W. Holmes" <[EMAIL PROTECTED]> wrote:
Mark Gordon wrote:

> 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


---------------------------------
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard

Reply via email to