Malko SQL/PHP pomost

Imam edna tablica s koli i tablica s rabotata na tezi koli. Iskam da izkarvam tablica na ekrana koito pokazva i sortira koia kola kolko chasa e rabotila (Chasovete se sahraniavat v "timep" poleto v tablicata "work" za kolite ot tablica "dma"). Vrazkata mejdu tablici work i dma e edno kam mnogo (toest ID ot dma e "pro_id" v "work")


Male dosega az nisto ne bih si razbral, dano shvastate kartinkata. Znachi izpolzvam slednoto zapitvane: "select pro_id, sum(timep), avg(timep), min(timep), max(timep) from work group by pro_id"

i posle slednia PHP kod za da otpechata tablicata na stranicata:


----------------------------
<?php
include("dbconnect.php");
$result = mysql_query("select pro_id, sum(timep), avg(timep), min(timep), max(timep) from work group by pro_id");
$num_fields = mysql_num_fields($result);

if($result){
echo "<table border=1><tr><th>Кола</th><th>Общо часове</th><th>Средно</th><th>Минимално</th><th>Максимално</th>";

echo "</tr>";
while($row = mysql_fetch_array($result)) {
echo "<tr align=left>\n";
for ($i=0; $i<$num_fields; $i++) {

echo "<td>";
if(!isset($row[$i])) { echo "NULL"; } else { echo $row["$i"]; }
echo "</td>";
}
echo "</tr>\n";
}



echo "</table>";

}

?>

----------------------

Koda uspeshno izvajda tablicata, no tova koeto iskam e v poleto "pro_id" vmesto da vijdam nomera (id) na kolata da vijdam imeto e (toest "dma" => "name"). Kak da go napravia??? Pls help

[линк]

Ama che sam prost......


Prosto mahnah cikala for i go napravih rachno za vsiaka edna kletka kato za parvata si napravih prepratka.....

ako ima po lesen nachin spodelete ;))

[линк]

$result = mysql_query("select dma.name, work.pro_id, sum(work.timep), avg(work.timep), min(work.timep), max(work.timep) from work LEFT JOIN dma ON dma.id = work.pro_id group by work.pro_id");

root@localhost#cd /pub
root@localhost#more beer