database question

[joker12]

Hi

I have a question and I'll try and explain the best I can
I have a submit form that catches info that I need and puts it into
a database so would I'd like to know if it is possible to deliver the same info from the form to multiple databases at the same time?

Thanks

[penders]

Your script that processes the form submission can do anything with the data. So yes, you can post to 1, 2, or however many databases you want. However, for larger systems, if you are posting identical information to multiple databases, it might be better to look at database replication?

[rocknbil]

Or .... have the programming that is using the multiple databases point to one database with a field defining the multiple sites.

id|site_id|common_field1|commonfield2.....


Select * from table where somefield='somecondition' and site_id=[id_of_this_site]