change domain, not forward...

[Guest]

im making a page for seo and need to change the domains that come out of the mysql database to a diferent domain,

So i.e.

affill.domain.com

i need to make the page display

store.mydomain.com instead of that other domain thats in the database.


how can i do that?

all the data is in the mysql dayabase with the wrong domain...