2. PHPRunner General questions
  3. retrieving specific record from table
This topic is locked

retrieving specific record from table

 		5/24/2011 3:55:29 AM
PHPRunner General questions
T
 tarang author

HI FORUM,

i m facing a problem, i have a table sub_admin through which a user get sign in and i store his/her session in $_session['username']. and now i want to retrieve some records from agent table. those agents who have been added by the current user. and in the agent table i have added sub_admin's id as a foreign key. i don't understand what to do.

thanks
J
 		Jane 5/24/2011

Hi,
I recommend you to have a look at theUser can see and edit their own records only option on the Advanced security settings dialog on the Securitytab:

http://xlinesoft.com/phprunner/docs/advanced_security_settings.htm
T
 		tarang author 5/25/2011

hi,

yes, you are right, but is their any way of manually retrieving records because i have implemented manual login system. not phprunner login.
J
 		Jane 5/26/2011

Hi,
you can use List page: Before SQL query event on the Eventstab to add custom WHERE statement to the SQL query and filter data.

Here is just a sample:

$strWhereClause = whereAdd($strWhereClause,"FieldName='some value'");