Здравейте. Искам да поставя в две колони топ потребителите в сайт за запознанства (5момчета и 5 момичета ), както в този сайт. Това е кода с който аз разполагам:
Благодаря предварително.[/url]
Код:
<?php
include("include/session.php");
include("lang/bg.lang");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<meta name="author" content="http://waisys.net/">
<title><?php echo $lang['title']; ?></title>
<link rel="shortcut icon" href="i/icon.gif">
<link href="facefiles/facebox.css" media="screen" rel="stylesheet" type="text/css">
<script src="facefiles/jquery-1.2.2.pack.js" type="text/javascript"></script>
<script src="facefiles/facebox.js" type="text/javascript"></script>
<script type="text/javascript" src="js/comment.js"></script>
<script type="text/javascript" src="js/over.js"></script>
<script type="text/javascript" src="js/func.js"></script>
<script type="text/javascript" src="js/prototype.js"></script>
<link href="i/main.css" rel="stylesheet" type="text/css">
<?php require_once('include/function.php'); ?>
</head>
<body>
<div id="container">
<?php include('include/header.php'); ?>
<div style="padding-left:0px;">
<div id="content">
<div class="top">
<table>
<?php
$i = 1;
$num = 1;
$q = "SELECT * FROM `users` WHERE sex='m' ORDER by `points` DESC";
$result = $database->query($q);
$num_rows = mysql_numrows($result);
if(!$result || ($num_rows < 0)){
echo "Error displaying info";
}
else if($num_rows > 0){
for($i=0; $i<$num_rows; $i++){
$uname = mysql_result($result,$i,"username");
$pic = mysql_result($result,$i,"pic");
$sex = mysql_result($result,$i,"sex");
$points = mysql_result($result,$i,"points");
?>
<tr><td valign="top" id="pos"><?php echo $num; ?></td><td><a href="userinfo.php?user=<?php echo $uname; ?>"><img src="<?php echo $pic;?>" width="130" height="158" style="border:2px solid #13B1E1;"></a><br><center>
<font color="#13b1e1" size="2"><?php echo $uname; ?></font>
<font color="#777777"> (<?php echo $points; ?> гласа)</font></center></td>
<?php if($i==3 or $i==7 or $i==11) { echo "</tr><tr>"; }
$num = $num + 1;
}
}
echo "";
?>
<?php
$s = 1;
$nums = 1;
$qs = "SELECT * FROM `users` WHERE sex='f' ORDER by `points` DESC";
$results = $database->query($qs);
$num_rowss = mysql_numrows($results);
if(!$results || ($num_rowss < 0)){
echo "Error displaying info";
}
else if($num_rowss > 0){
for($s=0; $s<$num_rowss; $s++){
$unames = mysql_result($results,$s,"username");
$pics = mysql_result($results,$s,"pic");
$sexs = mysql_result($results,$s,"sex");
$pointss = mysql_result($results,$s,"points");
?>
<td valign="top" id="pos"><?php echo $nums; ?></td><td><a href="userinfo.php?user=<?php echo $unames; ?>"><img src="<?php echo $pics;?>" width="130" height="158" style="border:2px solid #E22BAB;"></a><br><center>
<font color="#E22BAB" size="2"><?php echo $unames; ?></font>
<font color="#777777"> (<?php echo $pointss; ?> гласа)</font></center></td>
<?php if($s==3 or $s==7 or $s==11) { echo "</tr>"; }
$nums = $nums + 1;
}
}
echo "</table></div></div>";
?>
<?php
$sql = mysql_query("SELECT COUNT(*) AS 'number' FROM `users` LIMIT 10");
$a = mysql_fetch_array($sql);
echo "<div style=\"background-color:#FFF; width:535px; height:26px;\" align=\"center\">
</center>";
?>
<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>
<?php include('include/footer.php'); ?>
</div></div>
</body>
</html>Благодаря предварително.[/url]