Not sure what else to post. The variable I am trying to use is $animal_to_use which corresponds to a field in my database called animalid.
Now when this value comes over with an apostrophe in it, (for example ' 'butler's ignition #37') the program is truncating the value at the apostrophe. When I use VAR_DUMP($animal_to_use) to see my value I learn that instead of returning 'butler's ignition #37' -- it is returning 'butler'.
If I remove the apostrophe, things work and it returns the correct value.
When I researched the issue, it seemed that this code should work to return the entire field name
Code: Select all
$animal_to_use = mysql_real_escape_string($_POST['bulllist'])
but it didn't and I can't find any other functions to deal with the apostrophe and keep my id string together. So I'm kind of lost