2. PHPRunner General questions
  3. Query - Active / Inactive
This topic is locked

Query - Active / Inactive

 		8/31/2006 4:48:45 AM
PHPRunner General questions
M
 mmponline author

I have a field with active and inactive (Yes/No)option. What SQL query can I use in step 4 next to the field name to only show the active fields.
Thanks for any help.
Stephan
J
 		Jane 8/31/2006

Stephan,
what field type you use for this field?

If you use tinyint type use following query:

select `field1`,

`field2`

from `tablename`

where `field2`=1
M
 		mmponline author 8/31/2006

Work perfectly, thanks Jane