Pear inserting blank/empty strings instead of values.

[ShootingStar]

I'm trying to use PEARs autoExecute function to insert into a table. But the function is just inserting the strings as empty string and ot the actual value in the array, also the date is being inserted as 0000-00-00, the only values correctly inserted are the sysadm and affiliate bit field values.

Can anyone help?

$table_name = 'user';

	$fields_values = array(
	    'userid' => '1',
	    'email' => '[e-mail]',
	    'surname' => 'Surname',
	    'forenae' => 'Forename',
	    'dob' => '1972-10-01',
	    'password' => 'password',
	    'sysadm' => 1,
	    'affiliate' => 0
	);

	$res = $db->autoExecute($table_name, $fields_values, DB_AUTOQUERY_INSERT);

	if (PEAR::isError($res)) {
	    die($res->getUserInfo());
	}

[tomhath]

Make sure you have the column names right, including capitalization. It looks like there's at least one typo in the array assignment.

[ShootingStar]

Hi,
Thanks for your reply.
The typo in the field 'forename' was actually a deliberate mistake to try to generate an error in order to get the debuginfo().

When I run this code with the field names typed correctly (all my field names are lower case) I do not get any error messages - just as if the execute was successful.

All the fields are given values of a blank string in the table, except for date which is set to 0000-00-00 and the sysadm and affiliate fields which are set correctly to the value in the array.

Thank you for your time.