Many websites reading from the same database?

Davidc316

Hi,
does anyone know if it's possible to have lots of websites reading from a single MySQL database that's stored on (let's call it) a mother website?

I know that you can use redirection, but I'm really wondering if there's any way of doing this and still have each website retaining its own URL (so the user would not realise that they are reading a database from another website).

Many thanks!

drawmack

Yes, don't store the db on "another website" but rather on another server and then use the server parameter of [man]mysql_connect[/man]

Davidc316

Many thanks for that helpful response.

I'll do a little bit of tweaking over the next few days and see if I can apply your advice. If all goes well then I'll be sure to come back on and mark this one as resolved.

Cheers!

Roger_Ramjet

Just a point, if you want to use multiple domain names for the same scripts then SITE ALIAS in httpd.conf will do the job. We have the .com & .co.uk and whichever the user uses is what they will see, but it is all the same pages. With a bit of tweaking you can even have your pages alter their appearance according to which URL is used. Can save an awfull lot of work, only 1 set of scripts to maintain.