How can I place the data Fred "O'Brien" Bloggs into the VALUE attribute of an INPUT tag without breaking the HTML code?
Example ...
//Get name from users table where id is 1.
$res = @mysql_query("SELECT name FROM users WHERE ID='1'");
$name = mysql_result($res, 0, "name"); //Now contains Fred "O'Brien" Bloggs
//Now place $name into INPUT tag
<input type="text" name="name" value="<?php echo $name?>">
Whether I use double or single quote on the value attribute I'm going to get an issue due to the data being placed in it. To stop the error I could use mysql_real_escape_string, but I don't want to show escaped data to the user as that's not what they entered.
Please help a man nearly in tears!
