I have searched the forums and found that php runner does not support the wildcard function of %. I am trying to limit the data that certain users can see so I have done a table view on the master locations table (_table2). I only want the user to see all of his locations and not other data. His locations are all sports plus - city1, sports plus - city2, etc. If it were only 2 or 3 locations, I could program the filter. However this user has 30 locations now and they are adding them all the time. Here is my sql statements:
select `ID`,
`LocationName`,
`Address1`,
`Address2`,
`City`,
`State`,
`Zip`,
`Contact`,
`Phone`,
`Cell`,
`Email`,
`Salesman`
From `_Table2`
where LocationName=???????????
Is there anything that I can put in the coding to return all of the values for LocationName to begin with Sports Plus? I cannot do this under search or advanced search in the master table because this will give them access to all data.
Thanks,
kw