Query To Determine A Checkbox Greyed Out

[NFD]

Hi everyone,

Youve all been of great help to me in the pst, and Im hoping one of you can help me out with something.

What I want to do is have a query check a field of a table for data.
If data exists, then the checkbox is made available (ticked by default, can be changed)
If no data exists, then the box gets greyed out (unticked by default, obviously cant be changed)

In this example I am looking at a table called "customer" and the field is called "cellphone"

The tickbox will be part of a form, somethign like:

[code]    <td><input name="testing" class="textbox" type="checkbox" id="testing" value="1" /></td>[/code]

Hopefully what I am asking for has made sense.

Thankyou kindly in advance :)

[appeland]

Hello,
not sure what you are looking for , to disable a checkbox
(any form field actually) add disabled to the tag
[code]<input name="testing" class="textbox" type="checkbox" id="testing" value="1" disabled />[/code]

Make the query just insert the disabled bit if there's no data.
[code] <input name="testing" class="textbox" type="checkbox" id="testing" value="1" <? if (!$queryresult){echo "disabled"; } ?> /> [/code]

Have fun !
aNDI

[NFD]

Hi appeland, thankyou for your reply.

Ive just realised that the field in question is already being queried, so a slightly different approach is required.

Basically what I want is :
if $result[0]['cellphone']
returns an empty field
then for the tickbox to be set as disabled

Does that make sense?

[HeyRay2]

[code]
<input name="cellphone" class="textbox" type="checkbox" id="testing" value="1" <?php if (empty($result['cellphone']){echo "disabled"; } ?> />
[/code]

[NFD]

^^ That looks very close !

Currently it gives this error though:
[code]Parse error: syntax error, unexpected '{' in demo.php on line 379[/code]

Code looks like this:
[code]Line 379 <td><input name="cellphone" class="textbox" type="checkbox" id="cellphone" value="1" <?php if (empty($result['cellphone']){echo "disabled"; } ?> /> </td>[/code]
 

[appeland]

we are getting the "FIMBLING FEELING" here (for everyone who has kids that makes sense :) )

[code]<input name="testing" class="textbox" type="checkbox" id="testing" value="1" <? if (!$result[0]['cellphone']) {echo "disabled"; } ?>/>[/code]

The "is empty" is represented by the "!" in front of the variable.

tata,
Andi

[NFD]

Indeed it does make sense :)

I got it working using :
[code]<td><input name="cellphone" class="textbox" type="checkbox" id="cellphone" value="1" <? if (!$cellnumber){echo "disabled"; } ?> /> </td>[/code]

So thankyou to you both.

Last step now, displaying a snipet of text next to the box saying "Function disabled"
Is that possible?

[appeland]

Hiho,
besides the fact that i would not do that (not working should be enough),
you can use the same code to do what ever else you want to display beside it :
<? if (!$cellnumber){echo "this will not work , regardless what you do dudeldidum, hihi"; } ?>
regards,
andi

[NFD]

Hi Andi,

I figured that would work (and it does)
The message next to it was just a visual for that the customer does not have a cellnumber in the database
(an explaination for why it cant be ticked I guess)

All works, all is good.
Thankyou :)