I'm scraping data from third party sites using an html parser and then inserting the info that I need into MySQL. It just so happens that a lot of the info contains apostrophes in it. The trouble is that for the SQL query as follows:
INSERT INTO table (column) VALUE ('".$value."')
If the $variable
has an apostrophe in it, the query breaks. There is simply too much info for me to manually insert it all. It would be entirely too time consuming. Any suggestions for me to make this query work?