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" <holmes072000@xxxxxxxxxxx> 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
