|
Тема |
Malko SQL/PHP pomost |
|
Автор |
draggh (Admin) |
|
Публикувано | 01.04.04 00:40 |
|
|
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
|
| |
|
|
|