checkbox - how to select and siplay info from db

[avraamG13]

Hello,

I'm having a code that shows in a list checkbox and next the row name i have on my database
I want to select a checkbox and when i press display to show me tha information of the specific category if checked with my checkbox

ScreenShot:

Here is my code:

<table style="width: 100%">
   <tr>
      <td colspan="3" class="titlebarmain"><strong>Select &amp; View</strong></td>
   </tr>
   <tr>
      <td class="titlebarmainwhiter" style="height: 22px;">Selections</td>
      <td class="titlebarmainwhiter" style="width: 203px; height: 22px;">&nbsp;</td>
      <td class="titlebarmainwhiter">&nbsp;</td>
   </tr>
   <tr>
      <td>   
        &nbsp;<td style="width: 185px">   
<?php
$result = mysql_query("SELECT * FROM players_category ORDER BY sort_order ASC");
while($row = mysql_fetch_array($result))
  {
  $name = @$row["name"];
$cid = @$row["id"];
 
  echo "<tr>";
    echo "<td><input type=\"checkbox\" name=\"$name\" value=\"$cid\"> $name</td>";
 // echo "<td class='selOverview'>" . $row['name'] . "</td>";
  echo "</tr>";
}
?>
</td>
      <td style="width: 203px"></td>
      <td>&nbsp;</td>
   </tr>
   <tr>
      <td colspan="3">   
      <input type="submit" name="display_player_cat" value="Display" class='button' ></td>
   </tr>
</table>
<br>
 

P.S Please show me examples base on my code so i will understant please

Thank you

[prabirchoudhury]

<table style="width: 100%"> 
   <tr> 
      <td colspan="3" class="titlebarmain"><strong>Select &amp; View</strong></td> 
   </tr> 
   <tr> 
      <td class="titlebarmainwhiter" style="height: 22px;">Selections</td> 
      <td class="titlebarmainwhiter" style="width: 203px; height: 22px;">&nbsp;</td> 
      <td class="titlebarmainwhiter">&nbsp;</td> 
   </tr> 
   <tr> 
      <td>    
        &nbsp;<td style="width: 185px">
  <!-- have to declear a form here --->   
  <form name=form_chk action="self.php" method="POST">  
<?php 
$result = mysql_query("SELECT * FROM players_category ORDER BY sort_order ASC"); 
while($row = mysql_fetch_array($result)) 
  { 
  $name = @$row["name"]; 
$cid = @$row["id"]; 
  ?> 
 
   <tr>
  <td><input type="checkbox" name="<? echo $cid;?>" value="<? echo $cid;?>" <? if ($_POST[$row[id]] == $row[id]){ echo "CHECKED";}?> onchange="this.form.submit()" > <? echo $name; ?> </td>
    <? 
     if ($_POST[$row[organisationID]] == $row[organisationID]){
         // checking if the checkbox is being checked then bring the details 
         // and it is auto submit
    ?>
         <p>
         Category name: <? echo $row[name]; ?><br>
         other detail: <? echo $row[other]; ?><br>
         More details: <? echo $row[more]; ?><br>
      </p>
 
  </tr>
 
 
<? 
} 
?>
</form> 
</td> 
      <td style="width: 203px"></td> 
      <td>&nbsp;</td> 
   </tr> 
   <tr> 
      <td colspan="3">    
      <input type="submit" name="display_player_cat" value="Display" class='button' ></td> 
   </tr> 
</table> 
<br> 
 

hope tis gonna help you
My blog

My Site

[avraamG13]

Hey, thanks for your help,

Im getting this error all the time..

Notice: Use of undefined constant id - assumed 'id' in 
 

and the line:

  <td><input type="checkbox" name="<? echo $cid;?>" value="<? echo $cid;?>" <? if ($_POST[$row[id]] == $row[id]){ echo "CHECKED";}?> onchange="this.form.submit()" > <? echo $name; ?> </td>
 

Any ideas?

tHANK YOU

[Ciary]

  <td><input type="checkbox" name="<? echo $cid;?>" value="<? echo $cid;?>" <? if ($_POST[$row['id']] == $row['id']){ echo "CHECKED";}?> onchange="this.form.submit()" > <? echo $name; ?> </td>

this should solve it. i've put quotes around 'id' in the brackets

[avraamG13]

Notice: Undefined index: 77 in 'DIRECTION' on line 38
onchange="this.form.submit()" > [U20]Multiskillers 
 

same error with diferent numbers :)))

[Ciary]

i'm not sure about what's causing that notice. but you might consider the next code to avoid html-errors.

<td><input type="checkbox" name="<? echo $cid;?>" value="<? echo $cid;?>" <? if ($_POST[$row['id']] == $row['id']){ echo "checked="checked";}?> onchange="this.form.submit()" /> <? echo $name; ?> </td>
 

[avraamG13]

Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in 
 

is there any other way doing this? like java or something?

[Ciary]

java will make it even more complicated. the error you showed means you just forgot a ';' somewhere. you might check your code for more errors like these. don't forget that you need to end every command with ;