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
| if($_POST["champ"]=="id" || $_POST["champ"]=="etat")
{
$sql="SELECT ticket.idticket ticket.".$_POST["champ"]."ticket FROM ticket WHERE ticket.".$_POST["champ"]."ticket LIKE '".$_POST["search"]."%' ";
}
else
{
$sql="SELECT ticket.idticket, client.".$_POST["champ"]."cli FROM ticket, client WHERE ticket.mailticket=client.mailcli AND client.".$_POST["champ"]."cli LIKE '%".$_POST["search"]."%' ";
}
$result=mysql_query($sql);
$num_rows=mysql_num_rows($result);
$row=mysql_fetch_array($result);
if($num_rows==0)
{
echo 'Aucun ticket trouvé';
}
else
{
echo '<TABLE>';
for($compteur=1;$compteur<=$num_rows;$compteur++)
{
echo '<TR><TD align="right">'.$row[$_POST["champ"]."cli"].'</TD><TD> <A href="http://127.0.0.1/suivi/detail.php?idticket='.$row["idticket"].'">détail</A></TD></TR>';
$row=mysql_fetch_array($result);
}
echo '</TABLE>';
} |
