[SOLVED] How to count only one entry type.

[perficut]

I have a table that consists of names and addresses.

 

|FIRST|LAST|CITY|STATE|ZIP

 

If I want to count how many members are from a particulare state how can I do that.  I use the state abbreviations in my database.

 

heres what I have but obviosly it doesnt work.

// Make a MySQL Connection

$query = "select COUNT(*) from MDSRContractor WHERE State='IN'"; 
$result = mysql_query($query) or die(mysql_error());
$totalfromIN = mysql_fetch_array($result);
echo $totalfromIN;

[trq]

$query = "select COUNT(*) AS foo from MDSRContractor WHERE State='IN'"; 
$result = mysql_query($query) or die(mysql_error());
$totalfromIN = mysql_fetch_array($result);
echo $totalfromIN['foo'];

[perficut]

Thanks, I think that did it.

 

[fenway]

You can use mysql_result( $result, 0, 0 ) and then you don't need an alias, either.