Counting Rows in MySQL

[kumschick]

How can I count the rows?

example of:

[select * from TABLE where year='2003']

thx

[kumschick]

Forgot something:

$connection=mysql_connect($db_svr,$db_usr,$db_pwd)or die("<font color=\"#ff0000\">ERROR: Server Not Found</font>");
$database=mysql_select_db($db_nme,$connection);

$list=mysql_query("select * from $tbl_logc order by year desc",$connection);
while($row=mysql_fetch_array($list))
{
echo"$row[year]";
}

[015653]

I would do somethign like this.

$result=mysql_query($sql);
$number=mysql_numrows($result);

Echo "There were $number Records Found";

Regards,
015653