problem inputting data that has a single quote
Hi, I’m trying to type in a name of a song into an input field, for example:
I’ll Be Missing you
I’ll Be Missing you
This field is captured through $_POST and set to a variable $title
I then update the table with this new title. Once it is updated, all that is shown in the data is:
I
The single quote, and anything after it is gone completely.
Here is my query. How can I change this so it includes the single quote and everything after it?
PHP Code:
$sql = "UPDATE sheets SET artist = '$artist', title = '$title', active = '$activestatus' WHERE id = $value";
$result = mysql_query($sql) or die(mysql_error().'<br>'.$sql);
If more code is required to understand what I’m talking about, let me know.
View full post on Webmaster-Talk.com
Data, inputting, Problem, Quote, single
RSS Site Feed