On 10/6/06, Gordon Stewart <[EMAIL PROTECTED]> wrote: > Ive fixed it....
Spoke too soon... I got on tonight, to test it, & its still getting some errors.... Ive re-named my field names (& updated my scripts), so that I am not conflicting with any reserved words in MYSQL... However still get same errors... PHP CODE :- $query="UPDATE Yahoogroup SET `Statusa`='2', `datea`='$date', `emaila`='$from', `Subjecta`='$subject', `modemaila`='$approved', `webreada`='$webread', `IPA`='$IP' WHERE (`montha`='$month' and `groupa`='$grp' and `filea`='$file');"; echo "QUERY - \n$query\n"; $resulta=mysql_query($query) or die( "Unable to add data\n" . mysql_error()); ERROR :- (Ive changed Yahoogroup name & email etc) UPDATE Yahoogroup SET `Statusa`='2', `datea`='10 Jun 2006 07:35:04', `emaila`='[EMAIL PROTECTED]', `Subjecta`='[GROUPNAME] Re: Ahhh, i'm so confused!! :-)', `modemaila`='', `webreada`='1', `IPA`='66.94.237.52' WHERE (`montha`='200606' and `groupa`='GROUP' and `filea`='185'); Unable to add data 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 'm so confused!! :-)', `modemaila`='', `webreada`='1', `IPA`='66.94.237.52' WHERE' at line 1 -- 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/
