Jump to content


Photo

TABLE question 'ENUM' value? how to set it to zero?


  • Please log in to reply
2 replies to this topic

#1 bilis_money

bilis_money
  • Members
  • PipPipPip
  • Advanced Member
  • 621 posts

Posted 07 August 2006 - 01:19 AM

hi,

can someone please guide me on how to set an 'ENUM' value to '0' or '1'
i have only two values '0' and '1'.

How to set this using PHP?

thank you very much in advance.



#2 Kris

Kris
  • Staff Alumni
  • Advanced Member
  • 2,755 posts
  • LocationThe Internet

Posted 07 August 2006 - 06:34 AM

mysql_query("UPDATE `table` SET `field`='0' WHERE `id`='$id'") or die(mysql_error());


#3 bilis_money

bilis_money
  • Members
  • PipPipPip
  • Advanced Member
  • 621 posts

Posted 07 August 2006 - 12:37 PM

Thanks SA




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users