Msg#: 3504470 posted 10:25 am on Nov 14, 2007 (gmt 0)
thanks vince, i am modifying an out of the box ecommerce site to become 3 sites in 1.
now i have duplicated all the tables in the db like so: table_name becomes table_name1, table_name2, table_name3 or $my_var = 1; table_name$my_var
I want to do a global find and replace to change any reference to these table name, to save using global $my_var; in every function i want to use a constant. On top of this alot of the SQL statements are written using single quotes and not doubles so i would need to parse single quotes.
Its a wierd one i know but i really would like not to have to go through every script and manually alter the SQL statements to accomodate what i have done.
[edited by: Scally_Ally at 10:26 am (utc) on Nov. 14, 2007]