[Resolved] Analysing database fields

azurian

Hi,

This has been driving me insane, so any help would be greatly appreciated.

I have a SQL driven website, using a number of different fields within the database. One of those fields is called County and records where a person lives.

I need to be able to count the number of times a particular county appears in the database.

There are 89 possible counties at present, not all of which will actually appear in the database, so I don't want to have to do a mysql_num_rows routine.

Any ideas?

Pig

$result = mysql_query("SELECT SUM(column_name) AS some_name FROM table_name");
while( $row = mysql_fetch_array($result) ) echo("$row[0]<br>");

azurian

Thanks Pig

I'm still having problems.

This is my code:

$result = mysql_query("SELECT SUM (County) AS region FROM table WHERE 'ExpDate > $now'");
while( $row = mysql_fetch_array($result) ) {
echo("$row[0]<br>");
}

I get this error message:

Warning: Supplied argument is not a valid MySQL result resource.

I'm sure I'm doing something stupid