checkbox question and PHP WHERE

Anon

I have a question regarding checkboxes and PHP/javascript.

I got a checkbox that is checked 2 dropdown list gonna be active, how can i do this...

is this possible to do in HTML, i know you can do it in other programming language but haven't seen it in PHP och Javascript...

When the checkbox is unchecked your not gonna be able to use them, there for no droping down when you click at them. But when it's checked it should work...

And my other question is about PHP and WHERE command.

Here is the code i wish to work but don't know how...

$result = mysql_query("SELECT * FROM karaktarer WHERE id=$id, show=1");
$row = mysql_fetch_array($result);

Well this is the problem... As you see on the code behind WHERE id=$id, show=1
won't work...

show=1 is for data... in a tabel i got some data stored and i wishes to only show the data that got 1 in the field show but when i try it it says something about a error on line 13

(that will be $row = mysql_fetch_array($result); )

it works fine when i doesn't have show=1 in my code but i do not know any other way to do this.

please help!

Anon

I am not sure I understand the first part of your question but as to the second part:

result = mysql_query("SELECT * FROM karaktarer WHERE id=$id, show=1");

This is not a correct SQL statement. Try this:

result = mysql_query("SELECT * FROM karaktarer WHERE id=$id AND show=1");

Try and explain your first part a little better and I am sure someone will answer you.

Anon

Well the ting i wanted to know is...

IF igot 2 dropdown lists with info, BUT to access these lists you'll need to check a checkbox so they will be avaible.

If you ever have coded an other codelanguage like VB or so you can make your dropdown lists not avaible untill they have checked a checkbox or so... this is what i wanna do in PHP...

Is this better???

Anon

You will need to look into JavaScript and DHTML.

http://www.javascript.com

Anon

You can't do it in PHP. PHP is a server-side scripting language, whereas what you want to do is happening on the client side. (For that matter you can't do it in HTML!)

In the checkbox you'll have an onChange= attribute, that would contain a call to a JavaScript function. That function would look at the current state of the checkbox and enable/disable the dropdown box accordingly.