[SOLVED] code that will check a form box help

[randydg]

I need a way to determin if the box is supose to be checked it will check it.

the code I have bellow just puts the word check under the box instead of actualy checking the box.

 

    <td width="69"><span class="style4">Priority:</span>
<input name="priority" type="checkbox" id="priority" value="1">
<?php 
// get Current pri value 
    $db = mysql_connect("ip","user","pass") or die("Couldn't connect"); 
    mysql_select_db("database",$db) or die("Couldn't select database");
	$query="SELECT `priority` FROM `calls` WHERE `worksheet` = '$worksheetnum'";
	$result=mysql_query($query);
	$num=mysql_numrows($result);
	$i=0;
	while ($i < $num) {
	$priority=mysql_result($result,$i,"priority");
	$i++;
	};
if ( $priority == 1 )
{ 
echo "checked "; }
else
// do nothing
?>

[Alex]

<?php 
// get Current pri value 
    $db = mysql_connect("ip","user","pass") or die("Couldn't connect"); 
    mysql_select_db("database",$db) or die("Couldn't select database");
	$query="SELECT `priority` FROM `calls` WHERE `worksheet` = '$worksheetnum'";
	$result=mysql_query($query);
	$num=mysql_numrows($result);
	$i=0;
	while ($i < $num) {
	$priority=mysql_result($result,$i,"priority");
	$i++;
	};
$checked = ($priority == 1) ? 'checked="checked"' : NULL;
        echo '<input name="priority" type="checkbox" id="priority" value="1" ' . $checked . '>';
?>

[randydg]

if you dont want to help people then just go some where else. there is no need for your attitude.

it is uncalled for.

[knsito]

afaik He did what you wanted.

 

Take a breath and look again.

 

if you dont want to help people then just go some where else. there is no need for your attitude.

it is uncalled for.

[ASPF430]

if you dont want to help people then just go some where else. there is no need for your attitude.

it is uncalled for.

 

Bottom part - its fixed? I'd take that back!

[randydg]

I am sooo sorry, all i saw was the get a life thing i thought the top part was what i pasted. I am very sorry