[RESOLVED] Unable to get form to write to database

[lucianbeauty]

i have this form with two textfields where the user enters information. The the information in the textfields must be posted into a column (called MoreInfo) in the projects table in the database. For some reason it's not doing that. Can someone help me??

Here is the code for the save button:

if ($POST['SaveInfo']){
$value1 = $POST['textfield1'];
$value2 = $_POST['textfield2'];

$array = array($POST['textfield1'],$POST['textfield2']);
$array2 = array_filter($array,'blank');
$value = implode("|",$array2);
$query_update = "";

if (isset($GET['value'])){$AddInfo = $GET['value'];}
$query_update = "Update projects_copy set MoreInfo = '$value' where ProjectID = '$ID'";
$confirmation_message = "Additional Information for Project Recorded";
$update_project_result = mysql_query($query_update,$connection) or die (mysql_error());
}
else
{
if (strlen ($AddInfo) != 0)
{
$Select_query = "Select MoreInfo from projects_copy where ProjectID = '$ID'";
$Select_result = mysql_query($select_query,$connection) or die (mysql_error());
$row_Result = mysql_fetch_assoc($Select_result);
$result_array = explode("|",$row_Result['MoreInfo']);
}

if (isset($result_array[0])){$value1 = $result_array[0];}
if (isset($result_array[1])){$value2 = $result_array[1];}

}

[AsaSchool]

I have a question why you are using an array to insert the data into the database? If you only have to pieces of data that you need to insert, you can use a simpler method to do this. I take it that you are going to insert both form fields into one database column. If so assign them to a variable and insert them without the array.

Try something like:

$formItems = "".$POST['textfield1']." | ".$POST['textfield2']."";

$insertSQL = sprintf("INSERT INTO table (column) VALUES ('$formItems')");

mysql_select_db($database, $connection);
$Result1 = mysql_query($insertSQL, $connection) or die(mysql_error());

I dont know if it will work but its a much simple way to do this.

Hope this helps