Untitled

Check Checkbox depending on value in database

$getbranches = "SELECT * FROM branches ORDER BY naam ASC";

$querygetbranches = mysql_query($getbranches);

 

while($rijbranche = mysql_fetch_assoc($querygetbranches))

{

    echo "<tr>";

    echo "<td width='400'>";

    echo $rijbranche['naam'];

    echo "</td>";

    echo "<td>";

    $get2 = "SELECT * FROM bedrijf_branche WHERE bedrijf_id = '$id'";

    $query2 = mysql_query($get2);

    while ($rij20 = mysql_fetch_assoc($query2))

    {

        $branche_id = $rij20['branche_id'];

    }

    if($branche_id == $rijbranche['id_branche']){

        ?>

        <input type="checkbox" name="branche[]" value="<?php echo $rijbranche['id_branche']; ?>" CHECKED></input>

        <?php

    }

    else

    {

        ?>

        <input type="checkbox" name="branche[]" value="<?php echo $rijbranche['id_branche']; ?>"></input>

        <?php

    }

    echo "</td>";

}

       

<?php

 

$id = $_GET['id'];

 

// Output BRANCHES

$getbranches = "SELECT * FROM branches ORDER BY naam ASC";

$querygetbranches = mysql_query($getbranches);

 

while ($rijbranche = mysql_fetch_array($querygetbranches)) {

  echo '  <tr>' . "n";

  echo '    <td width="400">' . $rijbranche['naam'] . '</td>' . "n";

 

  // Output CHECKBOX

  $get2 = mysql_query("SELECT * FROM bedrijf_branche WHERE bedrijf_id = '" . $id . "' AND branche_id = '" . $rijbranche['id_branche'] . "'");

  $rij20 = mysql_fetch_array($get2);

  $branche_id = $rij20['branche_id'];

 

  if ($branche_id == $rijbranche['id_branche']) {

    $checkbox = '<input type="checkbox" name="branche[]" value="' . $rijbranche['id_branche'] . '" checked="checked" />';

  }

  else {

    $checkbox = '<input type="checkbox" name="branche[]" value="' . $rijbranche['id_branche'] . '" />';

  }

 

  echo '    <td>' . $checkbox . '</td>' . "n";

  echo '  </tr>' . "n";

}

 

?>

       

<input type="checkbox" name="branche[]" value="<?php echo $rijbranche['id_branche']; ?>" checked="checked" />

       

while ($rij20 = mysql_fetch_array($query2))