Multisites program

Multisites, script

[1234qwer]

Hi.

I have a large touristic site using joomla open source, now I need have 3 other site that present the same info in the site 1 but only selected by region.

What is your sugestion to have multisites?

Thanks.

[Webwork]

A shared database?

[1234qwer]

No, each one are stand alone, with different databases, but I like use the same database.

Then if I input one hotel in New York, it will be appear in the main site with all the hotels, but in the site for New York only will display the hotels in New York.

Thanks

[rocknbil]

I think Webwork was trying to say "that is your solution - a shared database." Because it is.

table main
id,title,address . . . .

table sites
id,mainid,siteid,other_site_specific_data.....

So on any given site you join the current site on the column mainid, for example

select main.title, main.address, sites.other_specific_data from main,sites where main.id=sites.mainid and sites.siteid=[this_site] and . . . . .

(or use left join, just an example)

It is the site-specific programming that would display only site-specific data, if you want.

[1234qwer]

I understand but in that case.

Will be unsecure access the main database from other address or web site?

Itīs the most secure way?

thanks