Replace sql field using PHP

tres · 19 Aug 2015 at 14:57

Can anyone help? I'm trying to use a script to replace a database value

PHP:

UPDATE data SET field = replace(MMSI,'235095793','Britannia');

Is what I have at the moment.
In the table 'data', I want to replace the value '235095793' with 'Britannia' from the column 'MMSI'

But it gives me a

Parse error: syntax error, unexpected T_STRING in /home/mission/public_html/ais/import.php on line 97

Any ideas? Thank you

tres · 20 Aug 2015 at 12:23

Thanks chaps. It turned out to be my retarded skills

tres · 20 Aug 2015 at 15:53

I'm certainly learning a lot!!
Like the 2 hours this morning because I forgot a semi colon.