Menu
Community /Pin to ProfileBookmark
@NogDogDec 15.2014 — #$result will be either a Boolean or a mysqli_result object, not a string, so there would be nothing (logically) to echo, assuming there are no errors.
(WARNING: totally untested, and I work almost exclusively with PDO these days, so who know what mistakes I made. ? )
No error messages but no data displayed either? SQL LAST / TOP 1
I don’t know why I’m not getting error reports and that there is nothing being shown, there is data in the database.
Login info ommited
I’m trying to echo back the last entry for a specific column.
[code=php]<?php
error_reporting(E_ALL);
error_reporting(-1);
$servername = “localhost”;
$username = ” “;
$password = ” “;
$dbname = ” “;
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
$sql = “SELECT TOP 1 Rc FROM computers
ORDER BY Rc DESC”;
$result = $conn->query($sql);
echo “$result”;
?>
Sign in
to post a comment2 Comments(s) ↴
0
@NogDogDec 15.2014 — #$result will be either a Boolean or a mysqli_result object, not a string, so there would be nothing (logically) to echo, assuming there are no errors.[code=php]
$conn = new mysqli($servername, $username, $password, $dbname);
if($conn->connect_error) {
die("<pre>Connect error: '".$conn->connect_error."'</pre>");
// do something "nicer" for production version
}
$sql = "SELECT TOP 1 Rc FROM computers
ORDER BY Rc DESC";
$result = $conn->query($sql);
if($result == false) {
die("<pre>Query error: '".$conn->error."'</pre>");
// ditto
}
// let's see what you got, then decide how you want to deal with it:
echo "</pre>RESULT:n";
while(($row = $result->fetch_assoc()) != false) {
print_r($row);
}
echo "</pre>";
[/code](WARNING: totally untested, and I work almost exclusively with PDO these days, so who know what mistakes I made. ? )