[solution][workaround] Oscommerce mysql NOW() date time function ..

By.

min read

My profile

Share this:

Well I needed to have a datetime field for a newsletter table …

No triggers allowed since we used a mysql 4.x database, so we used the default oscommerce insert query.

Problem: Datetime was 0000 etcetera…

Solution .. plain old insert_id’ing the darn thing ..

[code:1:756f15503a]function store_data($list_firstname, $list_lastname, $list_email_add, $list_on_off, $q_type) {
$sql_data_array = array (
‘customers_firstname’ => $list_firstname,
‘customers_lastname’ => $list_lastname,
‘customers_email_address’ => $list_email_add,
‘customers_newsletter’ => $list_on_off,
‘type’ => ‘directe_inschrijving’
);
tep_db_perform(TABLE_NEWSLETTER, $sql_data_array, $q_type, “customers_email_address = ‘” . tep_db_input($list_email_add) . “’”);
$insert_id = mysql_insert_id();
if($insert_id > 0)
{
$sql = ‘UPDATE ‘.TABLE_NEWSLETTER. ‘ SET datetime = NOW() WHERE id = ‘.$insert_id . ‘ LIMIT 1’;
mysql_query($sql);
}
}[/code:1:756f15503a]

Share this:

Leave a Reply

Your email address will not be published. Required fields are marked *