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
