1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| $requete = "SELECT tie_no, tie_nom, tie_prenom, tie_cpostal, tie_localite FROM tiers WHERE tie_no = '$no_client' OR (tie_nom LIKE '$m_nom'
AND tie_prenom LIKE '$m_prenom' AND tie_cpostal LIKE '$m_cpostal' AND tie_localite LIKE '$m_localite');";
fprintf($fp, "requete = %s\n", $requete);
$res = mysql_query($requete);
if ( ! $res )
die ('mysql_query error SELECT tiers_div' . mysql_error());
$result=array();
while ( $row=mysql_fetch_array($res, MYSQL_NUM) )
{
$nom_pren=$row['1'].' '.$row['2'];
$result[]=$row['0'];
printf("<a href='clients.php?client=$result[]' >");
printf("<p><span class=\"col4\">%s </span><span class=\"col15\">%s</span><span class=\"col7\">%s</span>
<span class=\"col10\">%s</span>\n</p>", $row['0'], substr($nom_pren,0,20), $row['3'], substr($row['4'],0,11));
printf("</a>");
} |
Partager