Rappports avec des résultats";
$getentryqry = mysqli_query($link, "SELECT * FROM entries WHERE section = '$chksection' AND (
data1 LIKE '%$chkstring%' OR
data2 LIKE '%$chkstring%' OR
data3 LIKE '%$chkstring%' OR
data4 LIKE '%$chkstring%' OR
data5 LIKE '%$chkstring%' OR
data6 LIKE '%$chkstring%' OR
data7 LIKE '%$chkstring%') GROUP BY repportid");
while($row = mysqli_fetch_array($getentryqry)){
$getreqid = mysqli_query($link, "SELECT * FROM repports WHERE id = ".$row['repportid']);
while($row = mysqli_fetch_array($getreqid)){
$repid = $row['id'];
$reqid = $row['reqid'];
$reptime = $row['inserted'];
}
$getcltid = mysqli_query($link, "SELECT * FROM request WHERE id = $reqid");
while($row = mysqli_fetch_array($getcltid)){
$clientid = $row['clientid'];
}
$getclient = mysqli_query($link, "SELECT * FROM clients WHERE id = $clientid");
while($row = mysqli_fetch_array($getclient)){
$clientname = $row['full_name'];
}
echo "
$clientname $reptime";
}
?>