Post by feedermania » Sun Feb 23, 2020 3:30 am

I want to get one value from other table. how can i do it? oc3.0.3.1

Here is the start code:

Code: Select all

$sql = "SELECT * FROM `" . DB_PREFIX . "order` WHERE 1 = 1";  
i want the 'order' table and the 'discount' (FLOAT(16,2)) value from 'customer' table. The 'discount' value is from 'customer' table.

Code: Select all

if($item == 'discount'){$xml .= '<DISCOUNT>'.htmlspecialchars($customer['discount']).'</DISCOUNT>'."\n";}
Last edited by straightlight on Sun Feb 23, 2020 10:34 am, edited 1 time in total.
Reason: Added code tags.

New member

Posts

Joined
Mon Jul 30, 2018 2:48 am

Post by straightlight » Sun Feb 23, 2020 10:35 am


Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Who is online

Users browsing this forum: No registered users and 9 guests