I have a problem binding booleans using mysqli_stmt::bind_param in PHP5.
The SQL query is the following: insert into
nvp_notes (subject,messageid,receivedate,read) values (?,?,?,?)
Where 'read' is a tinyint, either 0 or 1, as I've had issues with bit using mysqli. So the types that I list in bind_param are:
I've also tried 'sdsb' and 'sdss' but nothing seems to work, and I always get the message:
Warning: mysqli_stmt::bind_param(): Number of variables doesn't match number of parameters in prepared statement
When I remove the read field in the statement everything works fine. I've run out of ideas with this one. Surely bind_param works with booleans??