Uridium Posted October 11, 2008 Posted October 11, 2008 i want to set all my NPCS so they all have the same IMAGE picture i have the images in the USERS table but how do i make it so the NPCS get the same image without having to do it manually via the phpmyadmin. i was thinking something like UPDATE user_level=0 FROM users WHERE attpics='default.jpg' but that doesnt seem to work at the moment all the NPCS images for the attpics table is empty. Quote
Decepti0n Posted October 11, 2008 Posted October 11, 2008 Re: MYSQL to give pics to User_level 0 how ??? update users set attpics = 'default.jpg' where user_level = 0 Quote
Uridium Posted October 11, 2008 Author Posted October 11, 2008 Re: MYSQL to give pics to User_level 0 how ??? update users set attpics = 'default.jpg' where user_level = 0 Cheeers Deception your a life saver this has been driving me mental :) Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.