- LATEST NEW MUGG'S -
$numquery = "Select count(*) from Users";
$result = mysql_query($numquery, $db);
if (!$result){
echo mysql_error();
}else{
$row = mysql_fetch_row($result);
$num = $row[0];
mysql_free_result($result);
$rnum = $num - 6;
$muggquery = "select username, picurl from Users where banned != '1' limit $rnum, 5";
$mresult = mysql_query($muggquery, $db);
if (!$mresult){
echo mysql_error();
}else{
echo '';
while($mrow = mysql_fetch_assoc($mresult)){
echo '';
$picurl = $mrow['picurl'];
if (!$picurl){
$picurl = "images/profSample.jpg";
}
echo '
 ';
}
echo '
';
}
echo 'There are '.$num.' registered Muggs.Browse members.'; } include "google.txt"; $ct = $_GET[ct]; if (!$ct){ $ct = 0; } $hct = $ct + 12; $bmquery = "Select count(*) from Users"; $result = mysql_query($bmquery, $db); if (!$result){ echo mysql_error(); }else{ $num = mysql_fetch_row($result); $num_users = $num[0]; $i = 0; mysql_free_result($result); $pquery = "Select name, username, picurl, gender, DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(dob, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(dob, '00-%m-%d')) AS age, country, state_county, town from Users where banned != '1' limit $ct, $hct"; $presult = mysql_query($pquery, $db); if (!$presult){ echo mysql_error(); }else{ echo '
'.$row[name].' ['.$row[age].'] '.$row[country].' '; if ($sc){ echo $sc; }else if ($town){ echo $town; }else{ echo ' '; } echo ' | ';
$j += 1;
$i += 1;
}
}
echo '
| Previous Page | '; } if ($hct < $num_users ){ echo ''; } echo ' |