Xataface Forums

Hi, I am trying to insert into a table data that I am collecting from a different table. It works fine except the date field will not insert. When I echo back the value of the date field it comes back as 'Array'. This doesn't make sense the orginal table shows the date and saves the date just fine. Here is the code:

$con = mysql_connect("localhost:8889","root","root");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("ccap2012",$con);

$client = $record->val('client_id');
$street = $record->val('street');
$city = $record->val('city');
$state = $record->val('state');
$zip = $record->val('zip_code');
$move = $record->val('move_in'); //DATE VALUE HERE

$sql="INSERT INTO Addresses (client_id, street, city, state, zip_code, move_in)
VALUES ('$client','$street','$city','$state','$zip','$move')"; //DATE VARIABLE PROBLEM
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";
echo $move; // ECHO COMES BACK AS 'ARRAY' ???
mysql_close($con);
}

The $move variable is the date value I am trying to insert. All of the other fields insert into the table as expected. Thanks for the help

Code: Select all

$move = $record->strval('move_in'); //DATE VALUE HERE

strval because a date is a string.

Jean

I also recommend you escape (ie addslashes) to all of the inputs as this opens the possibility of an SQL injection.

-Steve

Jean, and Steve
Thank you very much, That worked like a charm