| Index
» Projects
» phpMyEdit
» Forum
» auto update when mysql value changes |
 |
richc
Joined: 05 Aug 2008
Posts: 2
Posted: 2008-08-05 01:08
Back to top
Reply with quote
|
we have multiple users logged in and using PME simultaniously. When one user adds a record no one else sees it until they refresh. Is there a way to set PME up so that as soon as the mysql table changes all users get the update? In other words if I add a record to the mysql table I would want anyone else who is logged on to see the new row so they know that it has been added.
|
ajh
Joined: 17 Dec 2003
Posts: 236
Posted: 2008-08-06 11:14
Back to top
Reply with quote
|
Be careful here as PME does not support transactions, so if you have multiple users editing the same record, you have the potential to end up with inconsistencies.
PME does not have the ability to notice changes.
Actually, there's probably a whole load of work that could be done to make PME transaction safe.
|
richc
Joined: 05 Aug 2008
Posts: 2
Posted: 2008-08-07 01:06
Back to top
Reply with quote
|
I have built in safeties for that. we use a form to input data into the table. the first field is a numeric value which is unique and must be for our system. therefore I made that field the key and made it unique in my database. we never end up with the same data entered twice however it sometimes takes an individule several minutes or even a day or two (depending on the person) to realize that their information never got entered due to the security.
|
|
Post new topic
Reply to topic
|
|
|
|
Login
Registration
Slovak
