I have 3 textboxes: Sur_name, Middle_name and Last_name, but 1 cell called name in MySQL table. The question is how to insert those 3 values in 1 cell??
Thanks in advance.
Here is my current code sample from my script:
Code: Select all
$sn = $_POST['sur_name'.$i]; // Sur Name
$gn = $_POST['given_name'.$i]; // Given Name
$mn = $_POST['middle_name'.$i]; // Middle Name
$other_stuff = $_POST['other_stuff'.$i]; // Other Entries
mysql_query("INSERT INTO a
(a.name, a.other_stuff)
VALUES ('".clean($sn)." ".clean($gn)." ".clean($gn)."', '".clean($other_stuff)."')")
or die(mysql_error());
Thank you again for your help.