trying another way

threestatedrive

ok, so let's try another way, how do i finish this code? I need to select all the common parishes in the parish column, add them all up and display the total number of entries for each individual parish.
After that's printed, i need to work out the percentages of each.
heres my query.

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT parish,count(*) FROM submit GROUP BY parish";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

am i totally off? and how do I print these results. basicaly, how do i finish what i need to do?

Xoid

I believe your select statement is correct, this will achieve your desired result:

i.e.

Parish1 : <Total>
Parish2 : <Total>
Parish3 : <Total>
etc...

then all you should need is another select statement to total all the entries so you can workout the percentage.

e.g. SELECT count(*) FROM submit

threestatedrive

Thanks for your reply
I'm fairly new at this though, what is the code to actually print out the parish name with the total number of entries next to it?

twcmad

<table>

while ($row = mysql_fetch_array($result))
{
  print("<tr><td>$row[parish]</td><td>$row[count]</td></tr>");
// this will return all the rows in the submit table
}

not sure what you need next ????


TWCMAD