It is currently Sun Dec 16, 2018 8:33 pm




Post new topic Reply to topic  [ 2 posts ] 
Visual Query Builder UserLogon 
Author Message

Joined: Thu Apr 09, 2009 5:45 pm
Posts: 3
Post Visual Query Builder UserLogon
Hi there,

I am currently building an update database page and want to show field values based on a UserLogon

however i can't seem to get the query right, can some one help me out?

Select
table.`field1`
From
table table
Where
(table.username = "UserLogon")

how do you get the value of the user logon in the query right?

greetings jim


Wed Feb 17, 2010 11:46 pm
Profile E-mail

Joined: Thu Jan 28, 2010 3:20 am
Posts: 5
Post Re: Visual Query Builder UserLogon
I'm new and not an expert database guy, but the tool has been great.

If you have security on (the users are logging in), you can set filter by user. dbQ sets a "Session variable" for the user based on their userlogin. It can then automatically filter so they only access records with a field that matches their userlogin within the record.

If you need to do a custom php to update the table, you can access the _SESSION variable also.


Fri Feb 19, 2010 11:52 am
Profile E-mail
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Copyright © 2004-2008 TheDevShop Ltd. All Rights Reserved