1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
| <table width="650" border="0" cellpadding="0" cellspacing="5">
<?php
$sql = "SELECT listing.NUMERO, listing.SITE, listing.TRAVAUX, qui.QUI, realise.REALISE, listing.COMMENTAIRE
FROM realise INNER JOIN (qui INNER JOIN listing ON qui.NUM_QUI = listing.NUM_QUI) ON realise.NUM_REALISE = listing.NUM_REALISE
WHERE listing.SITE = '$site' ORDER BY qui.QUI, realise.REALISE;";
//exécution de la requête:
$requete = mysql_query( $sql, $connec ) ;
//affichage des données:
while ($result = mysql_fetch_array($requete))
{
$site = $result['SITE'];
$travaux = $result['TRAVAUX'];
$qui = $result['QUI'];
$realise = $result['REALISE'];
$num = $result['NUMERO'];
echo "<tr>
<td width='600'><span class='TITRE2'>Travaux : </span>$travaux<br>
<span class='TITRE2'>Qui : </span>$qui</span><br>
<span class='TITRE2'>Realise : </span>$realise</span><br>
</td>
<td width='50' valign='top'><a href='travaux-update.php?num=$num' title='Modifier' ><img src='interface/modifier.png' width='20' height='20' border='0'></a></td>
</tr>";
}
?>
</table> |
