PDA

View Full Version : Query for ALL users


Sylvus
07-25-2003, 08:47 PM
Would anyone like to help me with this? I'd like to give every member on the forums an item but I'm stuck on the last part.

UPDATE items_user SET item$cat='3',points$cat='1',description$cat='You received this reward upon joining!',icon$cat='joinitem',itid$cat='0' WHERE userid=$bbuserinfo[userid]

It is the userid=$bbuserinfo[userid] part that I'm stuck on. How do I tell the query to run it for every user on the forum so that every user on the forum will receive a joined item?

Syl...

NTLDR
07-25-2003, 09:12 PM
Remove everything after the WHERE for it to apply to all users.