Categories > TinyButStrong general >

Trouble With a Table Row (2)

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
By: Maz
Date: 2005-12-20
Time: 13:57

Trouble With a Table Row (2)

Forgot to add the calling code:

$transactions = array();

$query = "    SELECT     t.order_id,
                    t.trans_id,
                    t.customer_id,
                    t.timestamp,
                    t.amount,
                    t.status,
                    m.members_display_name as customer
            FROM ".INV_PREFIX."transactions t
            LEFT JOIN ".IPB_PREFIX."members m ON (m.id=t.customer_id)";
           
$transactions = $db->get_results($query, ARRAY_A);

if($db->num_rows == 0)
{
    $transactions = array();
}

$TBS->LoadTemplate('content/modules/admin/view-transactions');
$TBS->MergeBlock('transactions', $transactions);
$TBS->Show();

And to say have a good Christmas!