I'm using php and a mysql database. I've a page where users can edit a name. When i select to edit the name "O'Brien" the only thing that appears in the input box is "O" before i start editing it. When these names are added i have the code below featured before it writes it to the database:
Code: Select all
$SurName=mysql_real_escape_string($_POST['inputSurName']);
Code: Select all
$query = "SELECT * FROM tblpupil WHERE PupilID = $id";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)) {
echo "<form method=post action=editname2.php?id=" . $row['PupilID'] . ">";
echo "<table border=0 cellSpacing=2 cellPadding=1 width=90%>";
echo "<tr><td colspan=4><FONT align=left color=#808080 size=5>Edit Pupil Name</Font></td></tr>";
echo "<TR><TD></td></tr><TR><TD></td></tr><TR><TD></td></tr>";
echo "<tr><td width=50%>First Name</td>";
echo "<td><input type=text name=editFirstName size=20 value='" . $row['FirstName'] . "'></td></tr>";
echo "<tr><td>Surname</td>";
echo "<td><input type=text name=editSurName size=20 value='" . $row['SurName'] . "'></td></tr>";
echo "<tr><td colspan=2 align=center><input type=submit name=submit value=Save> <input type=submit name=cancel value=Cancel></td></tr></table>";
}
Here the surname is for the pupil Stephen O'Brien is displaying just "O". Does anybody know how to fix this? Any help would be greatly appreciated.
Thanks guys!