Hi Guys, well i have reached that point again where i am stuck .
My initial search does exactly what it says on the tin. the second search is supposed to search for the serial number in another table then display the latency in a row. I have tried a few different things to get this working but the closed was actually putting the second search in the output table. Any ideas greatful.
include './includes/db.php';
$initialsearch = mysqli_query($link, "SELECT * FROM assets limit 1");
while($row = mysqli_fetch_array($initialsearch)){
$name = $row["name"];
$model = $row["model"];
$ip = $row["ip"];
$serial = $row["serial"];
$apsearch = mysqli_query($link, "SELECT latency FROM check_log where serial like '$serial' limit 5");
while($row1 = mysqli_fetch_array($apsearch)){
$latency = $row1["latency"];
}
echo"
<tr>
<td><font color=$color size='6px'> $name</td>
<td><font color=$color size='6px'> $model</td>
<td><font color=$color size='6px'> $ip </td>
<td><font color=$color size='5px'> $latency ms</td>
</tr>
</body>
";
My results from the above com out like this :
Name > Model > IP > Latency
Name > Model > IP > Latency
Name > Model > IP > Latency
Name > Model > IP > Latency
Name > Model > IP > Latency
what i want is :
Name > Model > IP > Latency > Latency > Latency > Latency > Latency
thanks all !