Search results

  1. T

    Inserting data from a <form> into MySQL w/ PHP?

    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...
  2. T

    Inserting data from a <form> into MySQL w/ PHP?

    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...
  3. T

    How to insert HTML code into MySQL tables?

    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...
  4. T

    PHP- how do you get SQL server to retrieve an EXACT match from a search?

    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...
Back
Top