Searching by more than one filed name

This topic is locked

Searching by more than one filed name	11/12/2006 2:59:18 PM
PHPRunner General questions
G gdude66 author Have changed the dbcommon entries when joining tables to lookup appropriate fields as follows if ("event"==$table && $field=="StudentID") return "`student`.`surname`"; However if I wanted it also to be capable of using `student`.`code` as well as a search lookup how could that be accomplished?


	Alexey admin 11/13/2006
	Graeme, you need to have both code and surname fields in your query. Add student.code field to your SQL query on the Edit SQL query tab in PHPRunner.