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); ?>