Да вади id-то на съюза.

J

joorkataa

Registered
Ами искам срещу всяко име на съюза да вади id-то от таблицата firms полето id



$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="2" bordercolor="#343434" 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))
{
echo "<tr><td>Ето тук да вади ID-то<center>".$i."</td><td><center>".$row['firm']."</td><td><center>".$row['obshto']."</td><td><center>".$row['kolko']."</td></tr>"; $i++; }
echo"</table>";
Увеличете...
 
$query = " SELECT id,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="2" bordercolor="#343434" 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))
{
$id=$row['id'];
echo "<tr><td>$id<center>".$i."</td><td><center>".$row['firm']."</td><td><center>".$row['obshto']."</td><td><center>".$row['kolko']."</td></tr>"; $i++; }
echo"</table>";
Увеличете...
:roll:
 
Хм те са две таблици, значи това измислих тогава:
<?
$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="2" bordercolor="#343434" 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'];
$s=mysql_fetch_array(mysql_query("SELECT id FROM firms WHERE name='$firm' ORDER BY id DESC limit 25"));
$d=$s['id'];
echo $d;
echo "<tr><td><center>".$i."</td><td><center>$d ".$row['firm']."</td><td><center>".$row['obshto']."</td><td><center>".$row['kolko']."</td></tr>"; $i++; }
echo"</table>";
?>
Увеличете...
виж какво ти изкарва $d;
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе