MySQL query to change discount pricing group

[Ells]

I'm working on a custom form that will allow members to enter a promotion code which will change their discount pricing group if it's valid.

So far everything is working fine except that I'm not sure how to put together a MySQL query that will change 'customers_group_pricing' in the 'customers' table. Can someone point me in the right direction?

[Ells]

Well this is what I have so far. It seems to give me access to the table, but I'm still unsure of how to update value stored there.

$promo_query = "SELECT customers_group_pricing
                FROM   " . TABLE_CUSTOMERS . "
                WHERE  customers_id = :customersID";
$promo_query = $db->bindVars($promo_query, ':customersID', $_SESSION['customer_id'], 'integer');
$promo = $db->Execute($promo_query);

[Ajeh]

The raw SQL for this is:

UPDATE customers SET customers_group_pricing = XX where customers_id = YY

Now just translate that in your code to use the correct values for what customers_group_pricing and which customers_id ...

If you look at some of the UPDATE statements via the Developers Tool Kit with a search on:
update

you should be able to see numerous examples of how UPDATE statements can be written ...

See if that helps you some ...

[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);

[Ajeh]

Thanks for the update that this helped you ...