It looks like you have a mySQLi connection but some of your code is still mySQL. This page would need a mySQL connection to work properly.
It looks like you have repeated recordset code too.
Try this:
1) Delete lines 42-49 (repeated code)
2) Open the rsBoats recordset from the server behaviors window and re-apply it (that should update it to mySQLi)
If it still doesn't work, attach the updated file in a reply to this post and I'll take another look.