  |
1 | 1 | | <?php |
| |
2 | 2 | | /* |
 |
3 | | - | $Id: account.php 500 2006-04-18 06:27:10Z hpdl $ |
| |
| 3 | + | $Id: account.php 685 2006-08-14 17:17:56Z hpdl $ |
|
4 | 4 | | |
| |
5 | 5 | | osCommerce, Open Source E-Commerce Solutions |
| |
6 | 6 | | http://www.oscommerce.com |
| |
|
|
 |
… |
|
15 | 15 | | function &getEntry() { |
| |
16 | 16 | | global $osC_Database, $osC_Customer; |
| |
17 | 17 | | |
|
18 | | - | $Qaccount = $osC_Database->query('select customers_gender, customers_firstname, customers_lastname, unix_timestamp(customers_dob) as customers_dob, customers_email_address from :table_customers where customers_id = :customers_id'); |
| |
| 18 | + | $Qaccount = $osC_Database->query('select customers_gender, customers_firstname, customers_lastname, date_format(customers_dob, "%Y") as customers_dob_year, date_format(customers_dob, "%m") as customers_dob_month, date_format(customers_dob, "%d") as customers_dob_date, customers_email_address from :table_customers where customers_id = :customers_id'); |
|
19 | 19 | | $Qaccount->bindTable(':table_customers', TABLE_CUSTOMERS); |
| |
20 | 20 | | $Qaccount->bindInt(':customers_id', $osC_Customer->getID()); |
| |
21 | 21 | | $Qaccount->execute(); |