MySQL query to change discount pricing group

[Ells]

Thanks! That is just what I needed. I'm learning SQL in the fly and didn't know what to look for.

I now have something like this which seems to be working fine.

$promo_query = "UPDATE " . TABLE_CUSTOMERS . " SET customers_group_pricing = 1 where customers_id = :customersID";
$promo_query = $db->bindVars($promo_query, ':customersID', $_SESSION['customer_id'], 'integer');
$promo = $db->Execute($promo_query);