I'm just learning to use nuBuilder, and I'm having trouble creating a report. I've added an activity as a report and an trying to get my php code to work properly. Because I couldn't get it to work, I've simplified and simplified to try to get the hang of it, so now I have this code:
Code: Select all
$sql = "CREATE TABLE $dataTable SELECT * FROM orders ";
$sql .= "JOIN customer ON orders.customerid=customer.id ";
$sql .= "WHERE orderid = 3";
nuRunQuery($sql);
Code: Select all
SELECT ``.* FROM `` WHERE = '150fdfe55007c0'
If somebody could point me in the right direction I would be very grateful.
Thanks!