Below is a database error message received when one of my user's attempts to minimize the chatbox:
Quote:
Database error in vBulletin 2.3.0:
Invalid SQL: UPDATE user SET chatbox=0 WHERE username='User's Name' mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's Name'' at line 1
mysql error number: 1064
|
Let's say the user's name is
User's Name. The error invokes because there is an apostrophe in the name itself. How do I account for this? Wouldn it be better to reference the user ID # as opposed to the actual name? If so, how do I do this.