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 30 31 32 33 34 35 36
| <table id="inquitable">
<tr>
<td class="col1"><label class="text8">Contact Name</label></td>
<td class="col2"><label class="text8">Sent</label></td>
</tr>
<tr>
<td class="col1"><label class="text8"> </label></td>
<td class="col2"><label class="text8"> </label></td>
</tr>
<?php
while($donnees = mysql_fetch_array($reponse))
{
$rep = mysql_query("SELECT First_name,Last_name FROM contacts WHERE Id_contacts=".$donnees['Id_contacts']."");
$check = mysql_fetch_array($rep);
$reponsesend = mysql_query("SELECT Send FROM reports_contacts WHERE Id_reports='$idrep' AND Id_contacts=".$donnees['Id_contacts'].""); // Requête SQL
$send = mysql_fetch_array($reponsesend);
echo '<tr>';
echo '<td class="col1"><label class="text9">'.$check['Last_name'].' '.$check['First_name'].''; echo '</label></td>';
if ($send['Send']==1)
{
$valeursend = '<label class="green">Yes</label>';
}
else
{
$valeursend = '<label class="red">No</label>';
}
echo '<td class="col2">'.$valeursend.'</td>';
echo'</tr>';
}
echo '</table>';
mysql_close(); // Déconnexion de MySQL
?> |
Partager