Combine first name and last name to Full name.
Posted: Sat Jun 03, 2017 3:23 pm
Combine first name and last name to Full name? Only 1 custom field Full name. I'm newbie. Help me
Thank you very much
Thank you very much
OpenCart Community Forum - Discuss shopping cart and e-commerce solutions.
https://forum.opencart.com/
Code: Select all
(SELECT CONCAT(c.firstname, ' ', c.lastname) FROM " . DB_PREFIX . "customer c ) AS fullname,
Code: Select all
$fullname = $customer_info['firstname'] . ' ' . $customer_info['lastname'];
And if you need to change it in admin order information page you can edit lines 52 to 57 in the file admin/view/template/sale/order_info.tplphamxuanvinh2110 wrote: ↑Sat Jun 03, 2017 3:23 pmCombine first name and last name to Full name? Only 1 custom field Full name. I'm newbie. Help me
Thank you very much
(SELECT CONCAT(c.firstname, ' ', c.lastname) FROM " . DB_PREFIX . "customer c ) AS fullname, => error.opencartboost wrote: ↑Sat Jun 03, 2017 3:35 pmDo you want to run query to get first name + last name as full name?
For query something like thisor combine to variable first name + last name?Code: Select all
(SELECT CONCAT(c.firstname, ' ', c.lastname) FROM " . DB_PREFIX . "customer c ) AS fullname,
For combine variable something like thisCode: Select all
$fullname = $customer_info['firstname'] . ' ' . $customer_info['lastname'];
As per replies, you can easily combine them for display purposes but it is not recommended for database because some payment gateways require first name and last name separate,phamxuanvinh2110 wrote: ↑Sat Jun 03, 2017 3:23 pmCombine first name and last name to Full name? Only 1 custom field Full name. I'm newbie. Help me
Thank you very much