2. PHPRunner General questions
  3. [SOLVED]  Problem with lookup searching.
This topic is locked
[SOLVED]

 Problem with lookup searching.

 		11/17/2010 11:40:24 AM
PHPRunner General questions
N
 netrebelos author

I have a database with 2 tables. I will tell you my problem with an example:
At the shops.category I write the type of food that the shop delivers.
Table ----> shops
name phone hours category id

Special 423435235 15-21 Hot-dog, pizza 1

The fat 23425325 18-22 Ice-cream, pizza 2

Foodland 2321312312 19-22 pizza, souvlaki 3
Table -----> category_names
name id

Hot-dog 1

pizza 2

Ice-cream 3

souvlaki 4
I use at the shop.category the lookup wizard and I can choose which type of food I would like to eat. (AT THE ADVANCED SEARCH PANEL)
Link field = category_names.name

Display field =category_names.name
THE QUESTION: WHAT I MUST DO SO WHEN I CHOOSE PIZZA FROM THE DROPDOWN LIST TO SHOW ME THE SHOPS THAT THEY SELL PIZZA???
How can a search result gives you not exactly the same option from the dropdown list but searching for the word inside the field in database? (such as like sql command)
THANK YOU
Sergey Kornilov admin 11/17/2010

You need to setup field as a multiline lookup wizard. In this case you will be able to search for all shops that have pizza or even for those that have pizza or souvlaki (great stuff by the way).
N
 		netrebelos author 11/18/2010



You need to setup field as a multiline lookup wizard. In this case you will be able to search for all shops that have pizza or even for those that have pizza or souvlaki (great stuff by the way).


I want the user to choose only one type of food.
Normal in my sql the command is

SELECT * FROM shops WHERE '<variable_of_the_dropdown_option>' like '%shops.category%'
I want the option that the user choose form the dropdown list to be compared with the shops.category field
Also I do not know what's the name of the variable...
Sergey Kornilov admin 11/18/2010

I see what you saying.
Unfortunately PHPRunner doesn't have a built-in option to handle this scenario and some manual coding will be required.
I recommend to post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL and PHPRunner order number. 'Demo Account' button can be found on the last screen in the program.
N
 		netrebelos author 11/19/2010

This option that I am telling you is very important!!! You must put it in the next version!!!! And you must fix also the browser combatibility!!!
R
 		Rigmantas 11/19/2010



This option that I am telling you is very important!!! You must put it in the next version!!!! And you must fix also the browser combatibility!!!


Hi

By category names you can seach in list page .

Rimantas
Sergey Kornilov admin 11/19/2010

netrebelos,
as I mentioned earlier - if you need help with this post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL and PHPRunner order number. 'Demo Account' button can be found on the last screen in the program.