Php不打印数据库信息

Question

I just set up a mysql data base, although my php isn't printing out the information that I want printed.

Here's what my code looks like (I've already connected to mysql and created a database successfully, I just need it to print out what I had inserted into it):

// will insert into the table
mysqli_query ($con, "INSERT INTO alarms(Title, Description, DT)
VALUES(getSucked, Agha will smd, 2013-08-05 00:15:12)");

//will print out what we just insert into the table, ie agha smd's
$result = mysqli_query($con,"SELECT * FROM alarms");
while ($row = mysqli_fetch_array($result))
{
echo $row['alarmID'] . " <br> " . $row['Title'] . " <br> " . $row['Description'] . " <br> " . $row['DT'];
}

//closing connection
mysqli_close($con);
echo "<br><br>connection has been closed";

The warning/error I keep getting is:

"Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in B:\DropBox\Dropbox\EbadlyAgha\Ebademinders.php on line 83"

Line 83 is where the while loop begins.

Answer 1

mysqli_query returns FALSE on failure.

try

if ($result) {
    while ($row = mysqli_fetch_array($result))
    {
    echo $row['alarmID'] . " <br> " . $row['Title'] . " <br> " . $row['Description'] . " <br> " . $row['DT'];
    }
}