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