This topic is locked

Login to a specific user

1/19/2007 14:30:03
PHPRunner General questions
jimhnet author

I have a single table which contains a username and password field, rest of the table is demographics related the to the user. The table is keyed on a standard incremented record number, plus I have index setup in the db on the username. We create the record and input the basic info from a separate full module version, with an administrator login info table . We log into the list module and use the add option to do this.
We have a separate version of the programs with only the edit, list, and export which we have the users log into to update their information in the table. We have the login option setup to allow them to only see and update their own information.
The problem we have is sometime it gets and lists only the one loging in their information for them to edit, sometimes it gets two or more in the list, to edit. The most I have seen is 19 records. The number of records in the table is around 10,000
This is a major problem!
Any suggestions
Thanks

Jim Freeman

Sergey Kornilov admin 1/22/2007

Make sure you choose correct OwnerID field.
According to your description autoincrement field needs to be selected as an OwnerID field.
If this error is reproducable send me your files and a smple database for investigation.

jimhnet author 1/23/2007

Make sure you choose correct OwnerID field.

According to your description autoincrement field needs to be selected as an OwnerID field.
If this error is reproducable send me your files and a smple database for investigation.


As usual your analysis was impecable. I had somehow set them to the address. Changed to the key field and it seems to be working fine.
Thanks
Jim Freeman
PS Is there anyway I can run the new version without php on the local machine?

Sergey Kornilov admin 1/23/2007

Jim,
PHPRunner itself don't need PHP installed however to run generated application PHP is required.
PHP is always required to run PHP pages and no software in the world (including PHPRunner) can change this.