CodingForums.com - View Single Post

Fou-Lu · 10-08-2012, 03:48 AM

You mean like an update query?

Code:

UPDATE userinfo SET plan = 0 WHERE timeleft = 0

?

SQL has its own if/else handling, look into the case syntax. Much like a switch really.

10-08-2012, 03:48 AM	PM User \| #2
Fou-Lu God Emperor Join Date: Sep 2002 Location: Saskatoon, Saskatchewan Posts: 15,645 Thanks: 4 Thanked 2,450 Times in 2,419 Posts	You mean like an update query? Code: UPDATE userinfo SET plan = 0 WHERE timeleft = 0 ? SQL has its own if/else handling, look into the case syntax. Much like a switch really.