I thought I had it figured out. I have been adding data to a blob type field from a textarea box on a form, this way, the copy entered goes into the field as a variable.
I used addslashes to filter the pesky quotes before they got put in.
Then, I went into phpMyAdmin, and tried to update a record. phpMyAdmin gave me an error because the data, lo and behold, had no slashes. Why? Why? Where did they go?. However, on another page, I am pulling that very same data out by way of a query, and using stripslahes to filter it before it hits the page, and it shows up perfectly. Why? Why is it showing up okay, but phpMyAdmin is telling me it has errors because of quotes?
I thought I had finally licked the quote problem, and here it is again, in a new confusing form. I need a definitive answer. Do blobs get rid of the slashes? What is happening?
I used addslashes to filter the pesky quotes before they got put in.
Then, I went into phpMyAdmin, and tried to update a record. phpMyAdmin gave me an error because the data, lo and behold, had no slashes. Why? Why? Where did they go?. However, on another page, I am pulling that very same data out by way of a query, and using stripslahes to filter it before it hits the page, and it shows up perfectly. Why? Why is it showing up okay, but phpMyAdmin is telling me it has errors because of quotes?
I thought I had finally licked the quote problem, and here it is again, in a new confusing form. I need a definitive answer. Do blobs get rid of the slashes? What is happening?