Member Avatar for danielbala

Hi all...........

I shud just how to use ENUM type in mysql..like shud i give any field in form in a website and how to assign a values for eg 0 for admin,1 for manager and 2 for the staff using phpmyadmin??

please help me.................

  • 2 Contributors
  • 1 Reply
  • 102 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by smantscheff
Member Avatar for smantscheff

Use an enum field with literal values. Define it as
myField enum('admin','manager','staff')
instead of numerical values.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.