Mysqli Prepared

[Pain]

Hi there. I am unsuccessfully trying to echo out a variable taken from the table...

 

This is a very simple mysqli class:

<?php

class Database{

function selectOne($table, $table_entry) {
global $mysqli;
$this->table = $table;
$this->table_entry = $table_entry;
if ($stmt = $mysqli->prepare("SELECT $this->table_entry FROM $this->table")) {
$stmt->execute();
$stmt->bind_result($variable2);
while($stmt->fetch()) {
return $variable2;
}
}
}


}
?>

 

 

And this is the main page.. Probably there's something wrong with those two lines..? Thanks for any help:)

<?php
$database->selectOne("ww3_users", "username");
echo $database->selectOne->variable2;
?>

Edited October 26, 2012 by Pain

[requinix]

selectOne() is a function, not a property. You have to call it like a function.

And it returns a single value, not an object. echo it directly.

echo $database->selectOne("ww3_users", "username");