Need Help Stringing Some Php Commands Together

[DirectoryConsultancy]

Hi, please could someone help me

I need to string several about 30 in total commands together in total

An example of the commands are:[code][
UPDATE `property` SET `description` = replace(description, "é", "e")
UPDATE `property` SET `description` = replace(description, "á", "a")
UPDATE `property` SET `description` = replace(description, "St.", "St ")
UPDATE `property` SET `description` = replace(description, "Ü", "u")
UPDATE `property` SET `description` = replace(description, "È", "e")
UPDATE `property` SET `description` = replace(description, "ü", "u")
UPDATE `property` SET `description` = replace(description, "ü", "u")
UPDATE `property` SET `description` = replace(description, "ß", "ss")
UPDATE `property` SET `description` = replace(description, "Ö", "o")/code]

Now I have to run each one separately and manually

I would like to be able to join them all together and run them all in one file and then I could set up a cron job for one file

Last time I tried I unwittingly deleted all the descriptions, nightmare!

Please can someone help me?

Thanks

[seandisanti]

it's not as readable, but you can nest your replace statements so that the return of one is used as the primary string for the next. luckily since whitespace doesn't matter your code can kind of reflect the nesting so it's easier to keep track of. here's an example doing 3 replacements in one line.

Code: Select all

UPDATE 'property'  SET 'description' = replace(
                                 replace(
                                    replace('description',"é", "e")
                                 ,"á", "a"),
                              "St.", "St ");

***edit***
fixed typo