Recent content by travo

MySQL keeps giving me a syntax error and will not insert any data (that comes from a textarea form) if it has an apostrophe (single quote) in it. I'm pretty sure there is some function that I need to run the data through before attempting to insert it into MySQL DB. Anyone know what function I...

MySQL keeps giving me a syntax error and will not insert any data (that comes from a textarea form) if it has an apostrophe (single quote) in it. I'm pretty sure there is some function that I need to run the data through before attempting to insert it into MySQL DB. Anyone know what function I...

I'm trying to insert HTML code into my MySQL table to be displayed later. MySQL table is a TEXT type, collation is UTF8_unicode_ci I wrote a simple PHP script that allows me to enter the HTML code into a standard HTML form TEXTAREA box....the code is then passed with the POST technique to...

This is my query to the server: $search= CKR; $query = "SELECT clubid FROM club WHERE clubid= '$search'"; It WILL retrieve all the "clubid's" from "club" that match "CKR." However, it also retrieves the "clubid's" that say "CKRA" or "CKRC". I only want it to retrieve the data that says CKR...