i have 2 input fields, single line and multiline input:
name:<input type=text name=name><br>
address:<texarea name=address></textarea>
once i input the data into MySQL, i found out that it cannot be edited anymore. but if i change the address input field to a single line input like name, it is ok to edit. why?
below is my code to submit both input into MySQL.
<?
require ("global.php");
if ($submit){
$address = str_replace("\n", "<BR>", $address);
$address = addslashes($address);
$sql="insert into $table (name,address) values('$name','$address')";
$db=mysql_connect("$host","$user","$pass");
mysql_select_db($database,$db);
$result=mysql_query($sql,$db);
if ($result){
header ("Refresh: 1 ;url=index.html");
echo "returning...";
}
}
?>