2. PHPRunner General questions
  3. display records if active
This topic is locked

display records if active

 		8/21/2007 8:08:50 AM
PHPRunner General questions
J
 jmsakura author

Hi, I want to be able to display records on the list page only if they are classified as live (with a tick) box via the edit page. What would the code be to do this please.
J
 		Jane 8/21/2007

Hi,
to filter records on the list page edit SQL query on the Edit SQL query tab.

Here is a sample:

select

field1,

field2,

field3

from tablename

where statusfield=1