mysqli issue

[fou2enve]

okay so im new to using mysqli, so im using basically the php example online to get it working. but i get a funky error:

 

Fatal error: Call to a member function fetch_field() on a non-object in C:\htdocs\index.php on line 218

 

ive bolded line 218 bellow.

 

any ideas as to what im doing wrong?

 

thanks

_KN

 

$stmt = $mysqli->prepare("SELECT id, name FROM friends");
$stmt->execute();

/* get resultset for metadata */
$result = $stmt->result_metadata();

/* retrieve field information from metadata result set */
[b]$field = $result->fetch_field();[/b]

printf("Fieldname: %s\n", $field->name);

/* close resultset */
$result->close();

/* close connection */
$mysqli->close();