!!! NEED SQL for removing credits via database !!!

Hi RZ,

I need a sql code to remove all credits to a new value of the users via database.

Thanks in advance.

PHP Code:

---

UPDATE Users
SET Credits='0' 


---

Cheer's should work..

Quote:

---

Originally Posted by jmandupree

PHP Code:

---

UPDATE Users
SET Credits='0' 


---

Cheer's should work..

---

That would remove the credits for all users. A where statement would be recommend

Well, He asked for that soo... Yeah

I don't know your table names and other stuff but:

Code:

---

$YOURSQLSHITHERE = "UPDATE Users SET Credits='0' WHERE id = '".$_POST['id']."'";

---

then add a simple form to submit a user id.