[PHP]Liczanie rekordow z 2 tabel, problem Opcje

[salva]

mam utworzone dwie tabele fchallenge i ftiebreak jak zrobic zeby mi z nich rekordy zliczalo do jednego pola pomocy

Kod

<?php
mysql_connect("mysql.cba.pl","","");
mysql_select_db("");
session_start();

if(isset($_SESSION['login'])){
echo 'Jestes zalogowany jako '
.$_SESSION['login'];
$query="SELECT COUNT(id) as ile FROM ftennis";
$result=mysql_query($query);

$A = mysql_fetch_assoc($result);
$num= $A['ile'];
$H="SELECT COUNT(id) as ile2 FROM fhokej";
$Hr=mysql_query($H);
$B = mysql_fetch_assoc($Hr);
$num2= $B['ile2'];
$pt="SELECT COUNT(id) as ile3 FROM fchallenge";
$wp=mysql_query($pt);

$P = mysql_fetch_assoc($wp);
$num3= $P['ile3'];
echo'
<table border="1">
<tr>
<td align="center" width="100">Dział</td>
<td align="center" width="100"> Temat</td>
<td align="center" width="100"> Posty</td>
</tr>
<tr>
<td align="center" width="100">
<form method="get" action="fstr2.php">
            <input type=hidden name=dzial value='.$rowdz['id'].'>
            <input type=submit value='.$rowdz['nazwa'].'tennis></form>
</td>
<td align="center" width="100">

'.$num.'
</td>
<td align="center" width="100">
'.$num3.'</td>
</tr>
<tr>
<td align="center" width="100">
<form method="get" action="dzial.php">
            <input type=hidden name=dzial value='.$rowdz['id'].'>
            <input type=submit value='.$rowdz['nazwa'].'hokej></form>
</td>
</td>
<td align="center" width="100">'.$num2.' </td>
<td align="center" width="100"> Posty</td>
</tr>
</table>';
}

?>

Ten post edytował salva 22.03.2010, 11:19:49