Can't get count right???

[Anon]

I am trying to get my counter to count only the records for a particular organization. Right now it is counting all records from the table.

Any suggestions would be gratefully appreciated>

$sql = "SELECT count(id) FROM $table_name";

$result = @($sql,$connection) or die("Couldn't execute query.");

$count = mysql_result($result,0,"count(id)");

This gives all 175 records that are in the table. However I had selected one organization from the table which only has 21 records and thats what I am trying to display.

Once again Thanks for any help.
:o) Ivan

[Anon]

Shouldnt there be any "where" in your sql-statment? like:

SELECT count(id) FROM $table_name where id='microblows'?

[Anon]

When I add the where statement "WHERE id='org'" it gives me the count of 1 which indicates one organization. I am trying to get the count of 21 for that 1 organization.

:o) Ivan

[Anon]

mysql> select count(location) from users where location='stockholm';
+-----------------+
| count(location) |
+-----------------+
| 4 |
+-----------------+

Works fine.

just do like this:

$count = mysql_fetch_array($result);

then the result will be in $count[0]

[Anon]

Thank You

I had to add the $ prior to the org. Works great. Thanks for all the help...

:o) Ivan