30-05-2006, 23:18
|
|
|
חבר מתאריך: 19.11.05
הודעות: 14
|
|
קוד PHP:
<? if($page == NULL) $page = 1; if($perpage == NULL) $perpage = 3; $sql=mysql_query("SELECT * FROM tblMembers WHERE gender='4' ORDER BY average DESC") or die(mysql_error()); $nump = mysql_num_rows($sql); $nump = $nump / $perpage; if(intval($nump) != $nump) $nump = intval($nump) + 1; $lim1 = ($page - 1) * $perpage; $query=mysql_query("SELECT * FROM tblMembers WHERE gender='4' ORDER BY average DESC LIMIT $lim1,$perpage") or die(mysql_error()); while($array = mysql_fetch_array($query)) { $sql2 = mysql_query("SELECT COUNT(title) AS `count` FROM tblComments WHERE FromMid = '$array[id]'") or die(mysql_error()); $object=mysql_fetch_object($sql2); ?> <tr> <td bgcolor=#D6E7F8 align="center"><img align="top" border="1" height="50" width="50" src="<?=get_username_picture_from_mid($array[id]);?>" hspace="3" vspace="1" alt="liron67" title="liron67"></td> <td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 2px solid #E5EFF9"><a href="viewprofile.php?Mid=<?=$array[id];?>" target="_top"><font color="#5C9FE1" size="2"><b><?=$array[username];?></b></font></a><br><font color="#CBE0F5" size="2"><b>בן <?=$array[age];?>, מאזור ה<?=$array[state];?></b></font></td> <td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 2px solid #E5EFF9" align="center"><font color="#284465" size="2"><b><?=$object->count;?></b></font></td> <td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 2px solid #E5EFF9" align="center"><font color="#284465" size="2"><b><?=$array[votes];?></b></font></td> <td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 2px solid #E5EFF9" align="center"><font color="#284465" size="2"><b><?=$array[points];?></b></font></td> <td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 2px solid #E5EFF9" align="center"><font color="#284465" size="2"><b><?=$array[average];?></b></font></b></td> </tr>
<? } ?> <tr class="alt2"> <td colspan="7" class="smallregular" align="left"> <? if (isset($_GET['page']) && $_GET['page'] == $nump) { // חזרה לדף הראשוני echo " [ <a href=\"$PHP_SELF?page=1\" style=\"text-decoration: none\"><font style=\"font-size: 9pt\" color=\"#97B201\"><b>התחלה</b></font></a> "; } $prev_page = $_GET[page] -1; //הדף הקודם if (isset($_GET['page']) && $_GET['page'] != 1) { // חזרה לדף הקודם echo "<a href=\"$PHP_SELF?page=$prev_page\" style=\"text-decoration: none\"><font style=\"font-size: 9pt\" color=\"#73839E\"><b>| הקודם</b></font></a> "; } for($I = 1; $I<= $nump; $I++) // לולאה להצגת העמודים { if($page != $I) { echo "<A HREF=\"$PHP_SELF?page=$I\"><font style=\"font-size: 9pt; font-family: Arial;\" color=\"#97B201\"><b>$I</b></font></A> <font size=\"2\" color=\"#73839E\"><b>|</b></font> "; }else{ echo '<font style="font-size: 9pt; font-family: Arial;" color="#73839E"><b>'.$I.'</b></font> <font size="2" color="#73839E"><b>|</b></font> '; } } $next_page = $_GET[page] +1; // הדף הבא if (isset($_GET['page']) && $_GET['page'] != $nump) { // מעבר לדף הבא echo "<a href=\"$PHP_SELF?page=$next_page\" style=\"text-decoration: none\"><font style=\"font-size: 9pt\" color=\"#73839E\"><b>הבא |</b></font></a> "; } if (isset($_GET['page']) && $_GET['page'] != $nump) { // מעבר לדף האחרון - סוף echo "<a href=\"$PHP_SELF?page=$nump\" style=\"text-decoration: none\"><font style=\"font-size: 9pt\" color=\"#97B201\"><b>סוף</b></font></a> ] "; }
?>
|