Ive fixed it.... Apparently its the 'backticks' that were the problem... Ive also updated the 'date' to VARCHAR...
[PHP] $query="UPDATE `Yahoogroup` SET `Status`='2', `date`='$date', `email`='$from', `Subject`='$subject', `modemail`='$approved', `webread`='$webread', `IP`='$IP' WHERE (`month`='$month' and `group`='$grp' and `file`='$file');"; [/PHP] Ive also removed the extra quote / Brackets from the edge. -- G NZ community groups - [EMAIL PROTECTED] NZ-Website space offered. Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/php-list/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
