Witam serdecznie mam taki problem sobie dosc spory staram sie zaimplementowac stronicowanie na mojej stronie ale niestety cos mi nie idzie czy ktos moglby mi pomoc?
Dodaje kod:
<?php
#############
// Club page
else if ($club) {
$query = "SELECT disco_list.*, disco_users.id as userid,login,shown, disco_comments.id as comments from disco_list LEFT JOIN disco_users ON disco_list.by = disco_users.id LEFT JOIN disco_comments ON disco_list.id = disco_comments.at WHERE disco_list.id = '$club' LIMIT 1;";
if ($list = mysql_query($query)) {
if (mysql_num_rows($list)) {
while ($o = mysql_fetch_array($list)) {
list($id, $login, $name, $street, $locality, $region, $added, $by, $desc) = array($o['id'], $o['login'], $o['name'], $o['street'], $o['locality'], $Lang['regions'][$o['region']], @date('m-d-Y',$o['added']), $o['by'], $o['description']);
?>
<h2 class="center"><?=$name?></h2><hr class="blackhr">
<div style="text-align: center;">
<?=resized("gallery/clubs/$id.jpg")?>
<hr class="blackhr">
<table style="width: 100%;">
<tr>
<td style="width: 30%; text-align: right;"><b><?=$Lang['Street']?></b></td>
<td style="text-align: left;"><?=$street?></td>
</tr><tr>
<td style="text-align: right;"><b><b><?=$Lang['Locality']?></b></b></td>
<td style="text-align: left;"><?=$locality?></td>
</tr><tr>
<td style="text-align: right;"><b><?=$Lang['Region']?></b></td>
<td style="text-align: left;"><?=$region?></td>
</tr><tr>
<td style="text-align: right;"><b><?=$Lang['AddedBy']?></b></td>
<td style="text-align: left;"><?=$login?>, <?=$added?></td>
</tr><tr>
<td colspan="2" style="text-align: justify;"><i><?=$desc?></p></td>
</tr>
</table>
<div style="text-align: right;">
<?php
$check = mysql_query("SELECT id FROM disco_members WHERE user = '$user_id' AND club = '$id' LIMIT 1;");
if (mysql_num_rows($check)) echo "<a href=\"disco.php?action=leave&id=$id\">${Lang['Leave']} »</a>";
else echo "<a href=\"disco.php?action=join&id=$id\">${Lang['Join']} »</a>";
#echo "<br /><a href=\"disco.php?club=$id#comment\">${Lang['Comment']} »</a>";
if ($auth_level == 'admin') echo "<br /><a href=\"admin.php?club=$id\">${Lang['Edit']} »</a>";
else if ($user_id == $by) echo "<br /><a href=\"disco.php?edit=$id\">${Lang['Edit']} »</a>";
?>
</div>
<?php
$list = mysql_query("SELECT disco_members.*, disco_users.* FROM disco_members LEFT JOIN disco_users ON disco_members.user = disco_users.id WHERE disco_members.club = '$id' ORDER BY disco_members.date DESC LIMIT 5;");
$rows = mysql_fetch_array($list);
$records = mysql_num_rows($list);
//print_r(array_values ($rows));
//echo ("records: ".$records."<br>");
$div = page_divider($records, 5, $page, "disco.php?club=$id");
//echo ("page: ".$page."<br>");
list ($nav, $min, $perpage) = array ($div[0], $div[1], $div[2]);
//echo ("nav: ".$nav."<br>"); echo ("min: ".$min."<br>");echo ("perpage: ".$perpage."<br>");
$query = "SELECT disco_members.*, disco_users.* FROM disco_members LEFT JOIN disco_users ON disco_members.user = disco_users.id WHERE disco_members.club = '$id' ORDER BY disco_members.date DESC LIMIT $min, $perpage;";
if ($list = mysql_query($query)) {
if (mysql_num_rows($list)) {
echo '<h3 class="left">'.$Lang['LastJoined'].'</h3>';
echo '<div style="text-align: center;">'.$nav.'</div>';
echo '<table style="width: 100%;">';
while ($o = mysql_fetch_array($list)) {
list($clubid, $login, $born, $shown, $desc, $name, $surname, $join) = array($o['id'], $o['login'], $o['born'], $o['shown'], $o['description'], $o['firstname'], $o['surname'], $o['joined']);
$shown = $shown ? $shown : $login;
if ($surname) $surname =" ".$surname;
$age = $born ? date('Y', $join) - @date('Y', $born).$Lang[' years'] : '';
?>
<tr>
<td colspan="2"><hr class="blackhr"></td>
</tr><tr>
<td style="text-align: center; background-color: black; width: 25%;">
<?=avatar("gallery/users/", "$clubid.jpg")?>
</td><td style="text-align: left; vertical-align: top;">
<a href="index.php?m=<?=$clubid?>"><?=$name?><?=$surname?></a><?
if($born) {echo(", ĹĽyĹ?");
if ($sex) echo("a"); echo(" lat ".$age);
};
?>
Efekty mozna zobaczyc pod adresem:
http://ksiegaumarlych.pl/disco.php?club=37
Jeśli ktos moze mi pomoc to bede bardzo wdzieczny