Hi

I'm trying to get the hang of mysqli since I've been using PEAR but my new free host won't support them. Can someone just give me a quick rundown of howw to add, find, update and delete items please?

I have a table 'user' with the following fields: userid, username, password, ash, level, about, email.

I'm trying to register a user with the following code:

Code:
$query="INSERT INTO user VALUES (?, ?, ?, ?, ?, ?)";
$stmt = $mysqli->prepare($query);
$stmt->bind_param('sssiss', $username, $pw, "0", 1, $aboutme, $email); 
$stmt->execute();
But I'm getting the following errors:

PHP Code:
All data must be fetched before a new statement prepare takes place in 
and

PHP Code:
Call to a member function bind_param() on a non-object 
Any help please?