[Resolved] Checkbox checked

[plasmahba]

Hi!

I'm making a form with some checkboxes and I would like some of them to be checked depending my database.

This is what Ive done but is not working I dont know why. Any help is appreciated

$result= mysql_db_query ("$DbName","SELECT * from mydb WHERE ID='$ID'");

<input name="one" type="checkbox" value="http://localhost/images/one.gif"
<? if($result['one']){echo"checked";}?>>

Thanx

[Erestar]

Sorry about that, jonno946 got it before I realized you weren't fetching any rows 😉

Erestar

[jonno946]

Your not putting your query results into an associative array.

Try this:

<?php

$query = mysql_query("SELECT * from mydb WHERE ID='$ID'", "$DbName"); 

$result = mysql_fetch_assoc($query);

?>

<input name="one" type="checkbox" value="http://localhost/images/one.gif" 
<?php if($result['one']) { echo "checked"; } ?>> 

[plasmahba]

Success!

This is what I did

<input <?php if (!(strcmp($row['one],"http://localhost/images/one.gif"))) {echo "checked";} ?> name="one" type="checkbox" value="http://localhost/images/one.gif">

Thank you everybody that help out!