Защо в този код
тези които са оцветени нямат id а тези които не са оцветени си им добавя Id-то от firms
PHP:
<h2 class='stranicamenu'><center>Класация Съюзи</center></h2>
<script type="text/javascript" src="overlib.js"></script>
<?php
function selfURL() {
$s = empty($_SERVER["HTTPS"]) ? ''
: ($_SERVER["HTTPS"] == "on") ? "s"
: "";
preg_match_all('/(.*)\//',$_SERVER['SCRIPT_NAME'],$lq);
$protocol = strleft(strtolower($_SERVER["SERVER_PROTOCOL"]), "/").$s;
$port = ($_SERVER["SERVER_PORT"] == "80") ? ""
: (":".$_SERVER["SERVER_PORT"]);
return $protocol."://".$_SERVER['SERVER_NAME'].$port.$lq[0][0];
}
function strleft($s1, $s2) {
return substr($s1, 0, strpos($s1, $s2));
}
$url = selfURL();
$vote = "index.php?a=suiuz&id";
$path = $url.$vote;
$broinastranica = 25;
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$redove = ($pageNum - 1) * $broinastranica;
$query = "SELECT firm,SUM(power) as obshto,COUNT(firm) as kolko FROM users WHERE firm != '' GROUP BY firm ORDER BY SUM(power) DESC LIMIT $redove, $broinastranica";
$result = mysql_query($query) or die('Error, query failed');
echo "<table border=1 width=450 align=center>";
echo '
<table width="100%" bgcolor="#343434" border="1" bordercolor="#979797" cellpadding="1" cellspacing="1">
<tbody><tr align="center" bgcolor="#313131">
<tr><td width="5%"><center>#</td><td><center>Съюз</td><td><center>Опит</td><td><center>Членове</td></tr>';
$i = $redove + 1;
while($row = mysql_fetch_array($result))
{
$firm=$row['firm'];
$d=$s['id'];
if ($i === 1){
$firm = '<font color="gold">' . $firm . '</font>';}
if ($i === 2){
$firm = '<font color="silver">' . $firm . '</font>';}
if ($i === 3){
$firm = '<font color="bronze">' . $firm . '</font>';}
$s=mysql_fetch_array(mysql_query("SELECT id FROM firms WHERE name='$firm' ORDER BY id DESC limit 25"));
$d=$s['id'];
echo "<tr><td><center>".$i."</td><td><center><a href='$path=$d'><b><u>$firm</u></b></a></a></td><td><center>".$row['obshto']."</td><td><center>".$row['kolko']."</td></tr>"; $i++; }
echo"</table>";
if ($i === 1){
$firm = '<font color="green">' . $firm . '</font>';}
$query = "SELECT COUNT(name) AS numrows FROM firms";
$result = mysql_query($query) or die('Error, query failed');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$broinastranica);
$self = $_SERVER['PHP_SELF'];
$nomeranastranici = '';
for($page = 1; $page <= $maxPage; $page++)
{
if ($page == $pageNum)
{
$nomeranastranici .= "<a href=\"\" class='text_border'> $page</a>";
}
else
{
$nomeranastranici .= " <a href=\"?a=rankingunion&page=$page\" class='g3link_border'>$page</a> ";
}
}
if ($pageNum > 1)
{
$page = $pageNum - 1;
$predishna = " <a href=\"?a=rankingunion&page=$page\" class='glink'> « </a> ";
$parva = " <a href=\"?a=rankingunion&page=1\"></a> ";
}
else
{
$predishna = ' ';
$parva = ' ';
}
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$sledvashta = " <a href=\"?a=rankingunion&page=$page\" class='glink'> » </a> ";
$posledna = " <a href=\"?a=rankingunion&page=$maxPage\"></a> ";
}
else
{
$sledvashta = ' ';
$posledna = ' ';
}
echo "<center>$parva $predishna $nomeranastranici $sledvashta $posledna</center>";
?>