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

Kingorgg · 19 Aug 2015 at 15:44

Can't you just use:

PHP:

UPDATE data SET MMSI='Britannia' WHERE MMSI='235095793';

?

sb89 · 19 Aug 2015 at 16:10

Can you show us the script? The error might not be due to the SQL but rather the code around it.

tres · 20 Aug 2015 at 12:23

Thanks chaps. It turned out to be my retarded skills

Black Dynamite · 20 Aug 2015 at 14:56

tres said:
Thanks chaps. It turned out to be my retarded skills

I've said that far too many times over the last few days

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.

antijoke · 20 Aug 2015 at 22:13

I spent three hours one morning tearing my hair out as to why something wasn't working, turns out I'd been viewing a duplicate of the local site and not the page I was updating.