Member Avatar for judas princess

i have created a database with username,age,contact,email.now i want a column in which we can show whether the user is active or not.what sholud we do?if we create a column named as status,what sholud be type of column?boolean or binary or something else...???
i am using php to edit delete and for other operations.everything is done except the status.i want that user can see who is active and who is not in his or her profile then what is the way to do it? please guide me..:-(

Edited by judas princess
  • 2 Contributors
  • 1 Reply
  • 230 Views
  • 5 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

boolean or binary or something else...?

Use an integer column, that way you enable the possibility to add new statuses later on.

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.