Hi everyone I am just going through the trial of PHPRunner to see if it's something I want to buy and I'm having some problems in Visual Editor getting to fo what I want.
I have set up a number of tables and only want loged in people to be able to see their own stuff. I have set all the parameters in Security and am now trying to use the loged in name while adding more data.
I have a form that allows then to add some information to a table but I want to only let them see certain entries that are associated with them
I set up 2 drop drop down lists that query the first table to allow the selection of fistly the USER that then selects from a second table what they can see.
I want to automate this process so I thought I could cut out the first drop down and set that via one of the session variables which I beleive to be userID.
When I set the properties of the second table to include the statement WHERE "memberName=" .$_SESSION["UserID"] when I run the form I get the following error
Unknown column 'viper' in 'where clause'
select `ID_tList`, `memberName`, `t_location`, `t_modelDescription`, `t_AP` From `kr_tournamentList` where `kr_tournamentList`.`memberName`='viper' limit 0,20
Am I doing something silly as I think this should work.
Thanks in anticipation
