Create a list of tickboxes dynamically

[chrisuk]

I am creating a mini site for a small poker league. Coming on just fine but there is one thing that I am not sure about.

 

Not all players play every week. When I add a game, I have dynamically generated drop downs that I can use which populate with players names from the database. I select this for 1st, 2nd and 3rd positions.

 

However, we keep track of the number of games played by each player, so if i only add these three, the play count will not be updated.

 

So, aswell as dynamic drop downs, I also have a dynamic list of players generated into a table, with their name and a checkbox:

 

<?php

$getplayers = "SELECT * from players";
$sql= mysql_query($getplayers) or die(mysql_error());
$row = mysql_fetch_array($sql, MYSQL_ASSOC);
extract ($row);

while ( $row = @mysql_fetch_array ( $sql ) ){ ?>

 <table width="551" height="27" border="0" cellpadding="0" cellspacing="0">
       <tr>
         <td width="212" height="27"><span class="style7"><span class="usertext"><? echo $row[player]; ?></span></span></td>
         <td width="47"><input type="checkbox" name="checkbox" value="checkbox" /></td>
         <td width="59"><span class="style7"></span></td>
       </tr>
       <? } ?>

 

So, not rocket science.

 

What i'm not too sure about is - what logic do I need to use to ensure that the players I select from the checkbox, have their games played count incremented by one?

 

Thanks folks

[BlueSkyIS]

are you looking for the SQL? for each player_id,

 

$sql = "UPDATE player_table SET number_of_games = (number_of_games + 1) WHERE id = '$player_id'";

[chrisuk]

Hi, Thanks for your reply.

 

that does help for part of the issue, but what I can't quite figure out is:

 

I only want to update one field in the database (the number of games played) for the players that I select via tickbox.

 

So, what code is needed to essentially "for each player selected, play_count = play_count + 1"

 

I use a while loop to generate the tick list, I assume it's some kind of extra loop based on tick boxes selected when the form is submitted?? As it's a dynamic list, I presume using $_post won't work? Unless it creates some kind of array?

 

I may be overly confusing matters!

 

Thanks again

[chrisuk]

bump