Hope someone has an idea on how to resolve my multiple db problem I have scanned the forum as well as the FAQ sites and really haven't found a simple answer.
Here is the scenario:
I have two databases set up for a DJ Booking system that I have created: Users and Booking
The idea is that those who want to submit booking requests have to first signup and then they can submit a booking inquiry to the system. To save time I didn't want to set up a relational database. Instead I set up one database that the user signs up on and is forced to add their account information to the users.db and another that they will receive a link to submit a booking inquiry to the booking db.
Each has their own db, count, log, html, cgi and cfg files. The only thing they share is auth and pass. And I have changed the links in each of the html files to correspond with the different databases.
It seems that everything is working fine until I log in as the admin. Then if I try to view all I have problems:
If I am in the users.db admin and click on the view all link for booking.db or
If I am in the booking.db application and click on the view all link for users
I am given the search for with "no search terms specified" and it does not display the list of records.
I noticed in my search for an answer that the db_key is mentioned. Is this the way to resolve the issue? If so, is there someone out there who knows the answer?
Thanks in advance
Cher
Here is the scenario:
I have two databases set up for a DJ Booking system that I have created: Users and Booking
The idea is that those who want to submit booking requests have to first signup and then they can submit a booking inquiry to the system. To save time I didn't want to set up a relational database. Instead I set up one database that the user signs up on and is forced to add their account information to the users.db and another that they will receive a link to submit a booking inquiry to the booking db.
Each has their own db, count, log, html, cgi and cfg files. The only thing they share is auth and pass. And I have changed the links in each of the html files to correspond with the different databases.
It seems that everything is working fine until I log in as the admin. Then if I try to view all I have problems:
If I am in the users.db admin and click on the view all link for booking.db or
If I am in the booking.db application and click on the view all link for users
I am given the search for with "no search terms specified" and it does not display the list of records.
I noticed in my search for an answer that the db_key is mentioned. Is this the way to resolve the issue? If so, is there someone out there who knows the answer?
Thanks in advance
Cher