Posted by Christoph Burschka on 11/20/06 17:32

Akhenaten wrote:
> The following snippet (for whatever reason) returns no value for the
> count. Suggestions?
>
>
> $arr = array ("A", "B", "C", "D", "E");
> foreach ($arr as $client) {
> $count = mysql_query('SELECT COUNT(*) from table where columnA =
> $client');
> echo "$client has $count";
> echo '<br>';
> }
>


1. You can't pass variables within single quotes.

Instead of '... $client' you either need "... $client" or '... '.$client

2. Strings in MySQL queries need to be surrounded by quotes (either single or
double).

This will work:

"SELECT COUNT(*) from table where columnA = '$client'"

as will this:

'SELECT COUNT(*) from table where columnA = "'.$client.'"'





--
Christoph Burschka

[Back to original message]