Handy code to count number of rows in MySQL. I use the code to search return results of how many posts are in on Catergry on my blog.
$db_con = mysql_connect("localhost", "username", "password");
mysql_select_db("database", $db_con);
$result = mysql_query("SELECT * FROM post WHERE catergory='Example'"$db_con);
$num_rows = mysql_num_rows($result);
echo $num_rows;
