Trouble with mySQLi Query

[Adam93]

Hi, 

So I'm not very familiar with using mySQLi, but I'm wanting to print a user's last name, depending on which user is logged in (obviously it needs to be their last name and not another users)

 

So, we're getting the session for the user and saving their username as $username

$user = Session::Get('current_user');
$username = $user->Get('username');

And then my query to display their lastname?

$result = $db->Select('lastname')->Where('username', '$username')->Get(Config::Get('db.table')); 
print_r($result)

But the query doesn't work, no error? Forgive my ignorance! >.<

[Ch0cu3r]

Variables are not expanded in single quotes. Remove the single quotes around the use of $username here

...Where('username', '$username')...

[Adam93]

Thanks, but it's now displaying;

Array ( [0] => Array ( [0] => 0 [lastname] => 0 ) )

[Ch0cu3r]

Is the $username set?

echo "Username is: $username";

[Adam93]

Whoops, so, cleared my sessions and logged in again, now it's displaying;

Array ( [0] => Array ( [0] => frank [lastname] => frank ) )

'frank' is the information in the table, which is correct, but I only want to display that piece of information, not "Array ( [0] => Array ( [0] =>"...

Any ideas?

[Ch0cu3r]

Change   print_r($result)  to   echo $result['lastname']

Edited September 5, 2014 by Ch0cu3r

[Adam93]

Now I'm not getting anything 

[Ch0cu3r]

Oh, sorry try   echo $result[0]['lastname']

[Adam93]

Thank you! Works fine now! Just a quick question for future, why the '[0]'?

:-)

[CroNiX]

Because it's an array within an array, so you need to access the first element (0), which gives you the array with your actual values.

[Adam93]

Ahh, thanks for you help!