Uridium Posted October 11, 2008 Share 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 Link to comment Share on other sites More sharing options...
Decepti0n Posted October 11, 2008 Share 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 Link to comment Share on other sites More sharing options...
Uridium Posted October 11, 2008 Author Share 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 Link to comment Share on other sites More sharing options...
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.