dropdown menu

SeRvErC

hi ,
i have 0 , 1 for each id in mySQL database . 0 = disable content . and 1 = enabled content . now how to show in dropdown menu with selected enabled/disable for update database ?? dynamic show anabled name if = 1 Or disable name if = 0 .
thanks

Bjom

How do you fill your dropdown menu?

You need to fill it from the DB, then it's a matter of writing a simple SELECT query with a proper WHERE condition along this:

SELECT name FROM myTable WHERE enableContent = 1;

SeRvErC

Bjom;10923407 wrote:
How do you fill your dropdown menu?

You need to fill it from the DB, then it's a matter of writing a simple SELECT query with a proper WHERE condition along this:

u unwitting !!! this MySQL line show content if enable .
EXAMPLE : now any conetnt is disable so = 0 - so in my admin panel in need to any dropdown menu or checked box for enabled content . So show in dropdown menu or checked box if conetnt enabled show YES or disabled show NO .
Thanks

mblack0508

SeRvErC;10923685 wrote:
u unwitting !!! this MySQL line show content if enable .
EXAMPLE : now any conetnt is disable so = 0 - so in my admin panel in need to any dropdown menu or checked box for enabled content . So show in dropdown menu or checked box if conetnt enabled show YES or disabled show NO .
Thanks

If I understand you, and I'm having a hard time doing so, I would use a checkbox instead of a drop down.

Bjom

And I strongly suggest you watch your language.

I took my free time to have a look at a problem, that you are incapable of solving yourself. I found that your description is not very understandable and tried to make something of it or get you to come up with a better one.

What it boils down to: I try to help you, and all you can think of is insulting me? I suggest you work on your personality issues and come back once you solved those.

Btw: a) you are not able to solve that yourself, b) your description is poor, c) your English is poor. So think about that "u" word again.

And off to the ignore list with you.

best regards

Bjom