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
|
foreach($_POST['coche'] as $key =>$val)
{
$prj_id = $val;
$sql = " select k2people.kid as kid,k2prjproject.*,date_format(prj_debut,'%d/%m/%Y') as prj_debut,date_format(prj_fin,'%d/%m/%Y') as prj_fin,k2prjtypeproject.*,k2people.rs as cli_rs, k2people.nom as cli_nom, k2people.prenom as cli_prenom, k2people.email as cli_email, k2people.tel as cli_tel, k2people.fax as cli_fax";
$sql .= " from (k2prjproject left join k2people on prj_kid = k2people.kid) left join k2prjtypeproject on prj_typ_id = typ_id";
$sql .= " where 1=1";
$sql .= " and prj_id = $prj_id";
$q = mysql_query($sql);
$R = mysql_Fetch_array($q);
<table cellpadding=0 cellspacing=0 width=100%>
<tr>
<td valign=top class=BG5 widht=10%>
<u><b>Projet</b></u><br><br>
<table cellpadding=0 cellspacing=0>
<tr><td>Nom du projet : </td><td><b>$R[typ_label] : $R[prj_nom]</b></td></tr>
<tr><td>Nom du client :</td><td><b>$cli_rs : $R[cli_prenom] $cli_nom</b></td></tr>
<tr><td>Chef Projet :</td><td><b>$R[nom]</b></td></tr>
<tr><td>Durée : </td><td>$barre</td></tr>
<tr><td>email :</td><td><b><a href="mailto:$R[cli_email]">$R[cli_email]</a></b></td></*tr>
<tr><td>Tel :</td><td><b>$R[cli_tel]</b></td></tr>
<tr><td>Fax :</td><td><b>$R[cli_fax]</b></td></tr>
</table> |
Partager