Counting Specific Rows....

[Skull]

well, i have a 'wrestling' website and im doing a title history section.

now i want to select from a database where the name and email specified match and where the row TITLE is World.

Now i can do that and it will come out World Title

but what i want it to do is if that information is in the database twice i want it to come out as World Title (x2) or if it is in the database three times World Title (x3) e.t.c..

I have tried a few different things to get it to do this but it won't work so I took the commands out and below is my 'origonal' script.

Well, I have attempted to tell you what I am trying to do so if anyone actually knows what i am talkin about and knows how to do it then plz reply...

<?
$SQL = "SELECT * FROM worldtitle WHERE NAME='$altname' AND EMAIL='$email' AND TITLE='World' ORDER BY -ID LIMIT 1";
$result = @($SQL) or die(mysql_error());
while($row = @mysql_fetch_array($result)) {
if($row["TITLE"] == "World"){
echo "World Title";
echo "\n<br>\n";
}
}
?>

[barand]

$SQL = "SELECT NAME,EMAIL,TITLE, COUNT(NAME) as ncount FROM worldtitle WHERE NAME='$altname' AND EMAIL='$email' AND TITLE='World'
GROUP BY NAME,EMAIL,TITLE";

ncount will give the number of titles.

hth

[Skull]

so after puttin that in how would I go around making it show up

World Title (x[amount of times here]) ?

[barand]

The count will be in $row['ncount']

[Skull]

ok thx it works