This topic is locked
4 replies
|
P
|
Phil_G 10/21/2009 |
|
I would guess you have to build it into the box query, using the WHERE clause with appropriate joins on your user tables hello, all my table in project have security settings so that users can see and edit they own data only. but, on add.php page i have 3 dropdown list, but security settings don't work good. user1 can see values in dropdown list from user2 is there any custom code to set up this thing to work... thanks Tomo PHPRunner 5.1 2503 trial |
|
|
F
|
futo author 10/21/2009 |
|
Hi Filippe, I would guess you have to build it into the box query, using the WHERE clause with appropriate joins on your user tables |
|
|
Sergey Kornilov admin 10/21/2009 |
|
Use WHERE clause to filter data in dropdown box. " UserID = '" . $_SESSION["UserID"] . "'"
" UserID = " . $_SESSION["UserID"]
|
|
|
F
|
futo author 10/22/2009 |
|
Use WHERE clause to filter data in dropdown box. If UserID is a text field: " UserID = '" . $_SESSION["UserID"] . "'"
" UserID = " . $_SESSION["UserID"]
|
|