hey I can get the winning email to work as long as the bidder stays logged in to the item page. when they log out it doesnt pick a customer id. I think it is because of the code
PHP Code:
where products_id '" . (int)$_GET['products_id'] . "'"; 
, can anyone help me and tell me how to change it and make the code pull the info from the database right or what i need to do in order to start a path for this thing to start working????



PHP Code:
global $db;
// get the current highest bid
$sql "select customers_id
    from  " 
TABLE_PRODUCTS_AUCTION "
    where products_id = '" 
. (int)$_GET['products_id'] . "'";
    
$auction_info $db->Execute($sql);
    
$customer_high_bidder $auction_info->fields['customers_id'];
    
$last_bid $db->Execute("select customers_id, customers_firstname, customers_lastname, customers_email_address
    from  " 
TABLE_CUSTOMERS "
    where customers_id = '" 
. (int)$customer_high_bidder "'
                                     "
);