When you store/get something from a db that is boolean...

[Atomiku]

Well, for example: When I have a users table and theres a banned row, "1" is banned, "0" isnt banned 🙂

What would you use?

[toplay]

Use TINYINT(1) or BOOLEAN if you have MySQL version 4.1.0 or higher.

hth.

🙂

[Elizabeth]

I use "y" and "n" only because I like to be annoying.

[Shrike]

Boolean is true/false, nothing more and nothing less. PHP just likes to do type conversion when it thinks you might need it.

[leatherback]

Just because I like to be digital I use 1 and 0

[Skull]

I use 1 and 0

[Jason_Batten]

<?php if(((1 != 0) && (0 != 1)) || (0 == FALSE))$TRUE = yes; echo $TRUE; ?>

EDIT: I didn't use no "doH!" :o

[devinemke]

i use a CHAR(1) field that defaults to NULL. i use "Y" for true and the default for false.

[Weedpacket]

I use a DBMS that has a native Boolean type.

[LoganK]

Don't ever use no double negatives!

Don't never use no triple negatives!

Sorry, off-topic, don't know where that came from. I use enum('yes','no') or enum('1','0'). Really it's a toss-up. I should standardize, but if aint broke, don't fix it!