Personal Talk, I am developing a system for videoconferences and this should include a Dashboard with some information, such as the total of videoconferences of the current day, the next day and the amount of VIP videoconferences.
To show the total VIP videoconferences I'm using following code:
$dataDoDia = date('Y/m/d');
$sqlVideo2 = "SELECT * FROM videoconferencias WHERE dia = '$dataDoDia' ORDER BY dia, horaInicio";
$resultadoVideo2 = mysqli_query($connect, $sqlVideo2);
if (mysqli_num_rows($resultadoVideo2) > 0) {
while($dadosVideo2 = mysqli_fetch_array($resultadoVideo2)) {
$vip2 = $dadosVideo2['vip'];
$contVip = 0;
while ($vip2 === 'SIM') {
$contVip ++;
}
echo $contVip;
}
}
The data coming from the bank are shown correctly, however the problem is that in the wilhe it is entering infinite Loop. Does anyone know where it might be wrong? Thanks!