Well, here goes nothing.
I'm trying to modify a script from directi.com
It basically queries their database and lists ALL the orders for a particular client id.
Within that client, there are various orders.
This is the result
orders.orderid ---> xxxxxxxxxxxx
entity.customerid ---> xxxxxxxxxxxx
entity.entityid ---> xxxxxxxxxxxx
orders.endtime ---> xxxxxxxxxxxx
orders.resellerlock ---> xxxxxxxxxxxx
orders.timestamp ---> xxxxxxxxxxxx
orders.customerlock ---> xxxxxxxxxxxx
entity.entitytypeid ---> xxxxxxxxxxxx
entity.currentstatus ---> xxxxxxxxxxxx
entitytype.entitytypekey ---> xxxxxxxxxxxx
orders.creationtime ---> xxxxxxxxxxxx
entitytype.entitytypename ---> xxxxxxxxxxxx
orders.creationdt ---> xxxxxxxxxxxx
entity.description ---> xxxxxxxxxxxx
The above is the result, if there's only 1 order.
IF there are multiple orders, it'll look like this
orders.orderid ---> xxxxxxxxxxxx
entity.customerid ---> xxxxxxxxxxxx
entity.entityid ---> xxxxxxxxxxxx
orders.endtime ---> xxxxxxxxxxxx
orders.resellerlock ---> xxxxxxxxxxxx
orders.timestamp ---> xxxxxxxxxxxx
orders.customerlock ---> xxxxxxxxxxxx
entity.entitytypeid ---> xxxxxxxxxxxx
entity.currentstatus ---> xxxxxxxxxxxx
entitytype.entitytypekey ---> xxxxxxxxxxxx
orders.creationtime ---> xxxxxxxxxxxx
entitytype.entitytypename ---> xxxxxxxxxxxx
orders.creationdt ---> xxxxxxxxxxxx
entity.description ---> xxxxxxxxxxxx
orders.orderid ---> xxxxxxxxxxxx
entity.customerid ---> xxxxxxxxxxxx
entity.entityid ---> xxxxxxxxxxxx
orders.endtime ---> xxxxxxxxxxxx
orders.resellerlock ---> xxxxxxxxxxxx
orders.timestamp ---> xxxxxxxxxxxx
orders.customerlock ---> xxxxxxxxxxxx
entity.entitytypeid ---> xxxxxxxxxxxx
entity.currentstatus ---> xxxxxxxxxxxx
entitytype.entitytypekey ---> xxxxxxxxxxxx
orders.creationtime ---> xxxxxxxxxxxx
entitytype.entitytypename ---> xxxxxxxxxxxx
orders.creationdt ---> xxxxxxxxxxxx
entity.description ---> xxxxxxxxxxxx
So, what I'd like to do is put the above information in a table
<tr>
<td>$result[orders.orderid]</td>
<td>$result[entity.customerid]</td>
<td>$result[entity.entityid]</td>
<td>$result[orders.endtime]</td>
<td>$result[orders.resellerlock]</td>
<td>$result[orders.timestamp]</td>
<td>$result[orders.customerlock]</td>
<td>$result[entity.entitytypeid]</td>
<td>$result[entity.currentstatus]</td>
<td>$result[entitytype.entitytypekey]</td>
<td>$result[orders.creationtime]</td>
<td>$result[entitytype.entitytypename]</td>
<td>$result[orders.creationdt]</td>
<td>$result[entity.description]</td>
</tr>