[GENERAL] boolean query

2001-09-28 Thread Ben-Nes Yonatan
Haloa! i got a boolean column (named 'seen') which contain the values '1' and '0' (depends on the item) now.. when i query the DB with the string "SELECT * FROM categories WHERE seen='1';" it brings me all of the items including those which seen='0' doesnt anyone know y? with thx in advance

[GENERAL] boolean query

2001-09-28 Thread Ben-Nes Yonatan
Haloa! i got a boolean column (named 'seen') which contain the values '1' and '0' (depends on the item) now.. when i query the DB with the string "SELECT * FROM categories WHERE seen='1';" it brings me all of the items including those which seen='0' doesnt anyone know y? with thx in advance