Advanced search question

This topic is locked

Advanced search question	11/4/2008 7:53:20 AM
PHPRunner General questions
S siegfried.hansen author Hello, I have two questions: Is there a way to have a form where the user can search by using a dropdown (which is a lookup) and, if he wants two searching criteria, to enter the second word in a text box below so both (the dropdown and textbox) to look in the same table field? Long story short, a search by two different words... Is there a way to implement portions of the generated code in different pages (i.e. if I have a website, in it's pages)? Thank you very much for your help. Regards, Siegfried


	Sergey Kornilov admin 11/5/2008
	You can implement this using field alias in SQL query: select ... fieldname, fieldname as fieldname2 from ... Now you can make both fieldname and fieldname2 appear on Advanced Search page and run OR searches.