There is a request for data output, which works well in phpmyadmin:

SELECT `android_php_post`.name, `clients`.orgazniz, `clients`.ardrees, `grafidotpis`.datapos, `grafidotpis`.timepos, `grafidotpis`.timezakr, `kod_vizova`.vid,`grafidotpis`.message FROM `android_php_post` , `grafidotpis` , `clients` , `kod_vizova` WHERE `android_php_post`.age = `grafidotpis`.idsotr AND `clients`.idadrs = `grafidotpis`.idadresorg AND `grafidotpis`.idviezd AND `grafidotpis`.datapos AND `grafidotpis`.timepos AND `grafidotpis`.timezakr AND `grafidotpis`.idviezd = `kod_vizova`.cod ORDER BY newid DESC

Trying to output all the same query in PHP table

 $sql = "SELECT `android_php_post`.name, `clients`.orgazniz, `clients`.ardrees, `grafidotpis`.datapos, `grafidotpis`.timepos, `grafidotpis`.timezakr, `kod_vizova`.vid,`grafidotpis`.message FROM `android_php_post` , `grafidotpis` , `clients` , `kod_vizova` WHERE `android_php_post`.age = `grafidotpis`.idsotr AND `clients`.idadrs = `grafidotpis`.idadresorg AND `grafidotpis`.idviezd AND `grafidotpis`.datapos AND `grafidotpis`.timepos AND `grafidotpis`.timezakr AND `grafidotpis`.idviezd = `kod_vizova`.cod ORDER BY newid DESC"; $result = $conn->query($sql); if ($result->num_rows >0) { while($row[] = $result->fetch_assoc()) { echo '</br><table class="live_filter" > <tr> <td class="title" style="width:100px;" align="center"> Сотрудник </td> <td style="width:70px;" align="center"> Контрагент </td> <td style="width:70px;" align="center"> Адрес </td> <td style="width:10px;" align="center"> Вид посещения </td> <td style="width:10px;" align="center"> Статус посещения </td> <td style="width:10px;" align="center"> Время/Дата посещения </td> <td style="width:20px;" align="center"> Сообщение </td> <td style="width:20px;" align="center"> Сообщение </td> </tr>'; echo ' <tr> <td class="title" style="width:70px; padding-left:10px;" >'.$row['name'].'</td> <td style="width:70px; padding-left:10px;" >'. $row['orgazniz'].'</td> <td style="width:70px; padding-left:10px;" >'. $row['ardrees'].'</td> <td style="width:20px;" align="center">'. $row['datapos'].'</td> <td style="width:20px; align="center">'. $row['timepos'].'</td> <td style="width:10px;" align="center">'. $row['timezakr'].'</td> <td style="width:20px; ">'. $row['vid'].'</td> <td style="width:20px; ">'. $row['message'].'</td> </tr>'; echo '</table>'; } } else { echo "No Results Found."; } $conn->close();

But, instead of displaying the result, we get a zadaze name for the columns, but again, surprisingly, it’s exactly the same as the number of lines that the query will output from phpmyadmin

Example of doubling:

 Сотрудник Контрагент Адрес Вид посещения Статус посещения Время/Дата посещения Сообщение Сообщение Сотрудник Контрагент Адрес Вид посещения Статус посещения Время/Дата посещения Сообщение Сообщение
  • Make echo var_dump ($ row) or start debugging, see what is in this variable after the query to fetch_assoc. Do not you know how to find out what is wrong when you know what should be? - Daniel Protopopov
  • one
    Thank you very much for pointing out where to look, the problem was solved with this line while ($ row = mysqli_fetch_assoc ($ result)) { - Weyner

0