<?php
$connection = mysql_connect("localhost","root","sigma321") or die ("Unable to connect to MySQL server.");
mysql_query("SET NAMES 'big5'");
$db = mysql_select_db(birth) or die ("Unable to select requested database");
$str_sql1= "select userid from birthday";
$str_sql2= "select userid from birthday where sex = 'M'";
$str_sql3= "select userid,username,sex,truncate((to_days(curdate()) - to_days(date))/365,0) as age from birthday order by userid DESC limit 0,15 ";
$result = mysql_db_query("birth", $str_sql1, $connection)  or die ("Unable to connect to MySQL server1.");
$totalnumber = @mysql_num_rows($result);
// require ('searchheader.inc');
$result = mysql_db_query("birth", $str_sql2, $connection)  or die ("Unable to connect to MySQL server."); 
$number = @mysql_num_rows($result);
$percentage= round ($number/$totalnumber*100);
$numberF = $totalnumber-$number;
$percentageF= 100 - $percentage;
require ('test.htm');
?>