PHP and checkboxes

[ianao]

Hi

 

I want PHP to fetch the data from a mySQL table and display on each line a checkbox. The checkbox should be either ticked or unticked depending on whether the data reads true or false.

 

Here is my code snippet:

 

while($row= mysql_fetch_array($rs) )

{

  $list .= "<tr>";

  $list .= "<td>".$row["id"]."</td>";

  $list .= "<td>".$row["Author"]."</td>";

  $list .= "<td>".$row["Page"]."</td>";

if($row["publish"]==1)

{

$publish="CHECKED";

}

else

{

$publish="";

}

  $list .= "<td><input type=\"checkbox\" .$publish.></td>";

  $list .= "</tr>";

}

$list .= "</table>";

$list .= "</form>";

echo($list);

 

 

The checkboxes that should be ticked do not display as ticked. Any suggstions would be very welcome indeed.

 

Best

Ianao

[JasonLewis]

It should throw an error.

 

Try this:

 

$list .= "<td><input type=\"checkbox\" ".$publish."></td>";

 

And you should do it like this:

 

$publish="checked='checked'";

[ianao]

That's it!

 

Fantastic! Thankyou so much for your help.

 

Best

Ianao