I have a chance to develop a script that is going to be used for a company with the possiblities of using it in 1000+ stores. Every store has a form with its conatct info on it and fill in areas. I need some thoughts and ideas about the way I am going to do this. See if this is the best way or please recommend another way. Here is the low down.
Store "A" is the main branch (script and db is going to be stored there). Store "B" is out west. Store "C" is out east. (ETC. they are all over the nation) Now store "A" logs on to the website storea.domain.com. From there they enter the info into a form and it is stored in databse "A". Store "B" logs in to the site storeb.domain.com and enters info into a form and saves it to database "b"....and this goes on for the 1000+ stores. Now you have 1000+ databases storing information. Is it possible to write a php script that when run by the main branch it can search the 1000+ databases for certain enteries? Also each store has to search its own database but not nation wide.
Is this the best way to do it or is there another way? They dont want software developed and it has to be accessed by the web.
Can you think of a differnet way to go about doing this project? I have read about php script searching 4 databases but nothing even comes close to 1000+. Is this possible ?
Any help, comments, or ideas are welcome. I need to find the best way to do this.
Thanks
