This topic is locked

Defaults to Admin

9/8/2010 4:48:31 AM
PHPRunner General questions
G
guroos author

Simple database of 2 tables.

Table 1 (files) has 2 fields 'username' & 'file'

Table 2 (users) has 3 fields 'username', 'password' & 'group'
The idea being users can login & see/edit their own files - currently working as expected.
The issue is with the 'admin' account when adding a new file and assigning a 'username' (from a drop-down looking at the users table) it defaults to itself 'admin'.

This can then be changed in edit, but I'm obviously doing something wrong.

A
ann 9/8/2010

Hi,
create an alias for this field on the Edit SQL query tab.

Then set up the alias as dropdown on the Visual Editor tab without any where clause.

Hide one of them in the Before Display event on the Events tab for the current user logged in.