How Do I Set New Password For Group of User

[hamado]

Hello , I`m looked for query to set new password for group of user , i do query but it`s gave me error message

this is the query i make :

UPDATE user, userfield SET user.password = MD5( MD5('password') . user.salt ) WHERE user.usergroupid = "2" and userfield.field7 = "KUW"

and this is the error message :

There was an error when trying to implement your query. Have been restored following information.
Error Number: 1064
Error description: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '. user.salt) WHERE user.usergroupid = "2" and userfield.field7 = "KUW" 'at line 1

i want to make it manually not by cron

thanks

Hamad Mubarak

--------------- Added [DATE]1227650522[/DATE] at [TIME]1227650522[/TIME] ---------------

jump , any one help me plz

--------------- Added [DATE]1227697030[/DATE] at [TIME]1227697030[/TIME] ---------------

jump , any one help me plz