|
|
 |
Last
5 Boys |
 |
| |
|
Name |
Gender |
Age |
Photo |
$tmp=mysql_query("SELECT id, fname, gender, birthday, pic1, pic2, pic3 FROM ".C_MYSQL_MEMBERS." WHERE status >= '7' AND gender = '1' order by regdate DESC limit 5");
$color='';
while($i=mysql_fetch_array($tmp)) {
$color = ($color == COLOR4) ? COLOR3 : COLOR4;
$name = (trim($i['fname']) == '') ? $i['id'] : $i['fname'];
$ph = (($i['pic1'] == '')&&($i['pic2'] == '')&&($i['pic3'] == '')) ? "nopic.gif" : $i['pic1'];
$photo = (trim($i['pic1']) == '') ? $i['id'] : $i['pic1'];
$age=abs(mysql2data($i['birthday'],1));
if ($i['pic1'] == '') echo "| ".$name." | ".$wg[$i['gender']]." | ".$age." |
 | "; else
echo "| ".$name." | ".$wg[$i['gender']]." | ".$age." |
| ";}
$tmp=mysql_query("SELECT count(id) as total FROM ".C_MYSQL_MEMBERS." WHERE status >= '7'");
$rows=mysql_fetch_array($tmp);$usc=$rows['total'];?>
|
|
 |
|
 |
 |
Last
5 Girls |
 |
| |
|
Name |
Gender |
Age |
Photo |
$tmp=mysql_query("SELECT id, fname, gender, birthday, pic1, pic2, pic3 FROM ".C_MYSQL_MEMBERS." WHERE status >= '7' AND gender = '2' order by regdate DESC limit 5");
$color='';
while($i=mysql_fetch_array($tmp)) {
$color = ($color == COLOR4) ? COLOR3 : COLOR4;
$name = (trim($i['fname']) == '') ? $i['id'] : $i['fname'];
$ph = (($i['pic1'] == '')&&($i['pic2'] == '')&&($i['pic3'] == '')) ? "nopic.gif" : $i['pic1'];
$photo = (trim($i['pic1']) == '') ? $i['id'] : $i['pic1'];
$age=abs(mysql2data($i['birthday'],1));
if ($i['pic1'] == '') echo "| ".$name." | ".$wg[$i['gender']]." | ".$age." |
 | "; else
echo "| ".$name." | ".$wg[$i['gender']]." | ".$age." |
| ";}
$tmp=mysql_query("SELECT count(id) as total FROM ".C_MYSQL_MEMBERS." WHERE status >= '7'");
$rows=mysql_fetch_array($tmp);$usc=$rows['total'];?>
|
|
 |
|
 |
|
 |
Statistic |
 |
| |
$color='';
$tmp=mysql_query("SELECT gender, count(*) as c FROM ".C_MYSQL_MEMBERS." group by gender order by c desc");
while($i=mysql_fetch_array($tmp)) {
$color = ($color == COLOR4) ? COLOR3 : COLOR4;
?>
| =$wg[$i['gender']]?> |
=$i['c']?> |
}?>
|
|
 |
|
 |
|