How to echo a single value from database with PHP

Question

I just started PHP and was wondering how you would echo a single value result from a database query.

Here's an example of what I'm trying to do:

$query = "SELECT `userID` FROM `users` WHERE username='bill'";
$result = $mysqli->query($query);

echo $result;

I figured out that $result contains an mysqli object based on the errors I was receiving, but can't get it to actually print out, say, "10001."

Answer 1

This is how you can do it

$query = "SELECT `userID` FROM `users` WHERE username='bill'";
$result = $mysqli->query($query);
$row = $result->fetch_assoc();
echo $row["userID"];

http://in2.php.net/mysqli_fetch_assoc