0

I have 100's of files that access a field in a mySQL DataBase. I had to change the field name and now I have to update 100's of files. The files read:

$sql = 'SELECT user_id, username, user_colour, user_birthday FROM '

I need it to now read:

$sql = 'SELECT id, nick, user_colour, user_birthday FROM '

I know I could go through all files and execute a replace 'user_id' with 'id', but that would take forever. Does anyone know a program to do this easier?

3
Contributors
3
Replies
4
Views
9 Years
Discussion Span
Last Post by woocha
0

Off the top of my head, Dreamweaver has a search and replace (CTRL-F) function that will allow you to batch replace an entire folder/website/etc.

While you are finding and replacing, you might consider replacing 100 instances of the same code with an include path to a single script to make future revisions less painful.

0

If you're on linux then grep is your friend. Also as Johnsquibb said, if you have probably over 5 instances of identical code, put it in one file then just include it.

0

Off the top of my head, Dreamweaver has a search and replace (CTRL-F) function that will allow you to batch replace an entire folder/website/etc.

While you are finding and replacing, you might consider replacing 100 instances of the same code with an include path to a single script to make future revisions less painful.

Hey..that sounds like a good idea. Do you have any advise on how to get started with something like that

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.