changing sql table names

[rednaxel]

here's my problem: my server account only gives me one mysql database. when i install an application (like phpWebsite) that has pre-set table structure, i need to have every instance of the table names that are within queries in the scripts appended with "domain1_app1_". the apps i am using have seperate dbconnect.php files. is there a function i can add to that file so that when the script queries "(select * from users)" it instead selects from the table "domain1_app1_users".

thnx

[[deleted]]

That would be a custom function, be very difficult.

Ofcourse you could simply look for "from " (from plus space) and replace it with "from domain1_app1_"
but what if you want to select from two tables at once?

Technically you could build a function that parses your query, but it quite complex to do.