qazs
09-17-2005, 10:36 AM
Hi,
This is more of advice on technique in web building. Hope I posted in the appropriate forum.
Ok, I have 2 sites, Admin and Member.
Both shared the same database, but are using different connections.
In Member, I'm using session to store database results, so I don't have to execute a mysql_query every now and then.
As you can see, if I made any changes to the database in Admin, users in the Member's site will not be updated.
So, what do you think is the best way to overcome this problem?
I'm thinking of using a table to store any updates made in Admin, and a script in Member will be consistently checking for updates.
Any other suggestions are welcome. Thanks.
This is more of advice on technique in web building. Hope I posted in the appropriate forum.
Ok, I have 2 sites, Admin and Member.
Both shared the same database, but are using different connections.
In Member, I'm using session to store database results, so I don't have to execute a mysql_query every now and then.
As you can see, if I made any changes to the database in Admin, users in the Member's site will not be updated.
So, what do you think is the best way to overcome this problem?
I'm thinking of using a table to store any updates made in Admin, and a script in Member will be consistently checking for updates.
Any other suggestions are welcome. Thanks.