Running multiple domains from 1 database

[player77]

What would be the best way to go about running multiple sites from 1 indexu database. For example lets say your directory contains categories like xbox, playstation, xbox360, etc and you wanna make a site that is focused only on xbox , how could I turn that particular category of content into another site just using a different template

[AllenNance]

When you find out if it's possiable be sure to first purchase multiple licenses.

[Frank71]

Not needed...
Frank

[esm]

with a single database, the only way I could think to do it would be to have a field in the appropriate tables ( idx_link, idx_category, etc ) so that you could modify the SQL query to add a WHERE clause using that field.

No small task.



.

[Frank71]

If you want to use a single database you can do several installatiuons all with the same database, but if you want to show only some categories here and others there I don't understand the need for one database ?
If you want this you have to cut all functions with global functions like index, hot, new and so on or you must change the sql request of each to a new defintion field you can set in each installation.
Search may be easier because you can modify the drop down to your needings.

If you ask me, forget the idea and do more installations...

Frank

[player77]

Esm

I had thought about making a sites table and then having a field in the link and category table that determined which sites the link or cat would show on.

Main thing I wanna do is take a category and only have that category and its data appear on the domain

[vittle]

on the 2nd install don't make any change to the database as this will effect your 1st install. Maunaly insert the category and links associated with it into index.html and delete the php tags that would call the other cats.

[player77]

Well what I did was make a field in the links table to determine which sites the link shows on and a table called sites to store the details on all the sites I setup. I went ahead and split the link table up as well so instead of 1 table storing links it stores them in different tables based on category so I dont endup with 50,000 links in idx_link slowing my site down. I added all the configuration in application.php such as site id etc and now all I have to do is upload the main .php files to each site and it all works perfect. Everything I need to edit a site is in a theme folder all on 1 install so very little work to maintain as many sites as i want

[vittle]

Well what I did was make a field in the links table to determine which sites the link shows on and a table called sites to store the details on all the sites I setup. I went ahead and split the link table up as well so instead of 1 table storing links it stores them in different tables based on category so I dont endup with 50,000 links in idx_link slowing my site down. I added all the configuration in application.php such as site id etc and now all I have to do is upload the main .php files to each site and it all works perfect. Everything I need to edit a site is in a theme folder all on 1 install so very little work to maintain as many sites as i want

cool! Sounds like a good way to do it!