PDA

View Full Version : How do I create a query for this???

cobradude
12-16-2003, 01:01 AM
For each member who has a style id of "1" I need to change to "2". The style id is in the user table.

Sorry if this is a stupid question... :) Thanks for any help.
g-force2k2
12-16-2003, 04:15 AM
UPDATE user SET styleid=2 WHERE styleid=1

Only problem I can think of is that the user's cookies on their pc have a preset cookie with the user's styleid so you may run into some problems there.

Regards,
g-force2k2
cobradude
12-16-2003, 03:31 PM
Thank you, much appreciated. Good point about the cookies too.
g-force2k2
12-16-2003, 08:32 PM
No problem glad that I could be of assistance.

Regards,
g-force2k2