Fatal Error: non-object
Hi, I'm still trying to get to grips with mysqli... little by little.
I can't see my mistake - I'm getting a fatal error 'Call to a member function bind_param() on a non-object'.
I've tried debugging with values for $title and $location but my form is passing them ok, and I've tried replace the bind_param section with directly inputted vaues but I still get a fatal error of 'non-object' on the execute().
I've tried looking online but to no avail. I assume 'non-object' means that '$statement' is seen as NULL?
Could anyone be so kind as to point out what I'm doing wrong?
$db = mysqli_connect("xxxx","xxxx","xxxx","xxxx") or die("Error " . mysqli_error($db));
$title = $_POST['title'];
$location = $_POST['location'];
$statement = $db->prepare("INSERT INTO jobBoard VALUES (?,?)");
$statement = $db->prepare("INSERT INTO jobBoard (title,description) VALUES (?,?)");
I was concentrating so hard on getting the new mysqli stuff right, that I made a simple error with the SQL :rolleyes: