Help me find a bug. data from the database table is not read. The cell table is empty. I do not even know how to debug. mysql_query($query): Resource id #5 value mysql_query($query): Resource id #5

part of the code:

 <?php // соСдинСниС $connection = mysql_connect ("localhost", "root") or die ("Ошибка соСдинСния с сСрвСром"); // созданиС Π±Π°Π·Ρ‹ Π΄Π°Π½Π½Ρ‹Ρ… $query = "CREATE DATABASE IF NOT EXISTS yogaclass"; $result = mysql_query($query) or die ("Ошибка ΠΏΡ€ΠΈ создании Π±Π°Π·Ρ‹ Π΄Π°Π½Π½Ρ‹Ρ…: ".mysql_error()); // созданиС Ρ‚Π°Π±Π»ΠΈΡ†Ρ‹ $db = mysql_select_db ("yogaclass", $connection) or die ("Ошибка ΠΏΡ€ΠΈ Π²Ρ‹Π±ΠΎΡ€Π΅ Π±Π°Π·Ρ‹ Π΄Π°Π½Π½Ρ‹Ρ…"); $query = "CREATE TABLE IF NOT EXISTS monday (time varchar(20), class varchar(20), instructor varchar(20) )"; $result = mysql_query($query) or die ("Ошибка ΠΏΡ€ΠΈ создании Ρ‚Π°Π±Π»ΠΈΡ†Ρ‹: ".mysql_error()); $query = "INSERT INTO monday (time, class, instructor) values ('16:45-16:50','Hatha','Ann Tagiltseva')"; $result = mysql_query($query) or die ("Ошибка ΠΏΡ€ΠΈ Π΄ΠΎΠ±Π°Π²Π»Π΅Π½ΠΈΠΈ Π΄Π°Π½Π½Ρ‹Ρ…: ".mysql_error()); $query = "INSERT INTO monday (time, class, instructor) values ('16:45-16:50','Hatha','Ann Tagiltseva')"; $result = mysql_query($query) or die ("Ошибка ΠΏΡ€ΠΈ Π΄ΠΎΠ±Π°Π²Π»Π΅Π½ΠΈΠΈ Π΄Π°Π½Π½Ρ‹Ρ…: ".mysql_error()); $query = "SELECT * FROM monday"; $result = mysql_query($query) or die ("Ошибка ΠΏΡ€ΠΈ Π²Ρ‹ΠΏΠΎΠ»Π½Π΅Π½ΠΈΠΈ запроса: ".mysql_error()); echo 'ΠžΡ‚Π»Π°Π΄ΠΎΡ‡Π½Π°Ρ информация: ', mysql_query($query); // Π·Π½Π°Ρ‡Π΅Π½ΠΈΠ΅ (ошибка) mysql_query($query): Resource id #5 while ($row = mysql_fetch_array ($result)){?> <td><?php $row['time']?></td> // Π² ячСйках Π½ΠΈΡ‡Π΅Π³ΠΎ Π½Π΅Ρ‚ <td><?php $row['class']?></td> <td><?php $row['instructor']?></td> <?php } mysql_close($connection); ?> 

    2 answers 2

    ummm ... and frolic is not necessary to write? via echo

     <td><?php echo $row['time']; ?></td> // Π² ячСйках Π½ΠΈΡ‡Π΅Π³ΠΎ Π½Π΅Ρ‚ <td><?php echo $row['class']; ?></td> <td><?php echo $row['instructor']; ?></td> 
    • It seems as if php short tags are enabled, and so it is possible. - ferrari
    • @ Oleg B, if php short tags are enabled, then you need <? = $ Row ['class']; ?> - mountpoint

    I would even say it's better.

     <td><?php echo !empty($row['time']) ? $row['time'] : 'empty';?></td> // Π² ячСйках Π½ΠΈΡ‡Π΅Π³ΠΎ Π½Π΅Ρ‚ <td><?php echo !empty($row['class']) ? $row['class'] : 'empty';?></td> <td><?php echo !empty($row['instructor']) ? $row['instructor'] : 'empty';?></td>