- $result = SQL_QUERY_ESC("SELECT company, position, gender, surname, family, street_nr1, street_nr2, zip, city, country, phone, fax, cell, email, url, tax_ident, status, sponsor_created, last_online, last_change, receive_warnings, points_amount, points_used, remote_addr, warning_interval, refid, ref_count
-FROM `{?_MYSQL_PREFIX?}_sponsor_data`
-WHERE `id`='%s' LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT
+ `company`,`position`,`gender`,`surname`,`family`,`street_nr1`,`street_nr2`,`zip`,`city`,`country`,
+ `phone`,`fax`,`cell`,`email`,`url`,`tax_ident`,
+ `status`,
+ UNIX_TIMESTAMP(`sponsor_created`) AS `sponsor_created`,
+ UNIX_TIMESTAMP(`last_online`) AS `last_online`,
+ UNIX_TIMESTAMP(`last_change`) AS `last_change`,
+ `receive_warnings`,
+ `points_amount`,`points_used`,`remote_addr`,`warning_interval`,`refid`,`ref_count`
+FROM
+ `{?_MYSQL_PREFIX?}_sponsor_data`
+WHERE
+ `id`=%s LIMIT 1",