CODEWITHSUNDEEP
mysql
Abu Mohanad
Abu Mohanad

Reputation: 63

I got empty result with MySQL

I have tried to show the whole table data in MySQL. Rows are (User_id, first_name, last_name, and dept). There is no result when I refresh the page. 

<?php
$servername = "fdb19.awardspace.net";
$username = "2598428_db";
$password = "password";
$dbname = "2598428_db";


$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

$sql="SELECT * From users";
$result = $conn->query($sql);
while($res = mysqli_fetch_array( $result )) {
echo $res['AverageSatisfactionScore'];
} 

?>

Upvotes: 2

Views: 51

Answers (2)

NIMI
NIMI

Reputation: 19

just try to print the total count of your result set by

echo mysqli_num_rows( $result );

it will print total number of records in the result

Also try to print whole row by

print_r($res);

insted of using

echo $res['AverageSatisfactionScore'];

Upvotes: 0

Ludo
Ludo

Reputation: 121

Your echo is false.

You need to display a valid column name like : echo $res['id'] or echo $res['dept'].

Upvotes: 2

Related Questions