Echo Yes or No instead of 1 or 0
May I trouble someone to poke me in the right direction.
I have a column in my user table called "UserFeature"
In my insert form I have a check box called "Featured User" which writes a 0 to the database by defalt (unticked) and writes 1 to the database when checkbox is ticked. Works a treat.
On my user Details page, Featured User echo's either 1 or 0. How would get this to echo either Yes or No instead.
Secondly, The Check box has no tick in on the update page when the db shows as 1. Im Sure this is going to be a SQL statement, but again any help in the right direction would be appreciated.
Hope that this make sense.