Hi all,
I am new to this forum... It has been awhile since i have worked with arrays, and i am starting to pull my hair out with this little issue i am having..
I hope someone can help me out with it, or even possibly show me a better way of doing this.
I am creating an web based hockey stats program for a ball hockey league.
I have a score sheet where they enter data. The score sheet gets constructed in a single form with a row for each player on the team. there are 12 players on each team so there will be 24 rows of data in the end.
I need to store each players game stats individually in a stats table where i can keep track of player game stats for each game.
here is the code for my form.
Code: while ($r_hmp = mysql_fetch_array($q_hm_play)) {
echo "<tr>";
echo "<td>".$r_hmp['jnum'] ."</td>";
echo "<td>".$r_hmp['lname'].", ".$r_hmp['fname']." ( ".$r_hmp['position'] ." )<input type='hidden' name='pid[]' value='".$r_hmp['id']."'></td>n";
echo "<td><input type='text' name='gp[]' size='2' maxlength='2'></td>n";
echo "<td><input type='text' name='g[]' size='2' maxlength='2'></td>n";
echo "<td><input type='text' name='a[]' size='2' maxlength='2'></td>n";
echo "<td><input type='text' name='pns[]' size='2' maxlength='2'></td>n";
echo "<td><input type='text' name='pim[]' size='2' maxlength='2'></td>n";
echo "<td><input type='text' name='gw[]' size='2' maxlength='2'></td>n";
echo "<td><input type='text' name='pg[]' size='2' maxlength='2'></td>n";
echo "<td><input type='text' name='sg[]' size='2' maxlength='2'></td>n";
echo "<td><input type='text' name='pa[]' size='2' maxlength='2'></td>n";
echo "<td><input type='text' name='sa[]' size='2' maxlength='2'></td>n";
echo "<td><input type='text' name='soa[]' size='2' maxlength='2'></td>n";
echo "<td><input type='text' name='sog[]' size='2' maxlength='2'></td>n";
echo "<td><input type='text' name='psa[]' size='2' maxlength='2'></td>n";
echo "<td><input type='text' name='psg[]' size='2' maxlength='2'></td>n";
echo "<td><input type='text' name='mj[]' size='2' maxlength='2'></td>n";
echo "<td><input type='text' name='mc[]' size='2' maxlength='2'></td>n";
echo "<td><input type='text' name='gm[]' size='2' maxlength='2'></td>n";
echo "<td><input type='text' name='gr[]' size='2' maxlength='2'></td>n";
echo "<td><input type='text' name='mt[]' size='2' maxlength='2'></td>n";
echo "</tr>n";
$hi++;
one the score keeper clicks the save button i am trying to create a multi-leveld array where i store 24 rows of data
each row should hold the players id and his particular stats for the game.
i tried to setup my array so i could loop troug it using two counters $player[$i][$x] where i would be the count of the row and x being the stat data.
here is the code i have tried, and to no avail.... your help with this would be greatly appreciated. I am sure there is a simple solution to this, but i am stuck and can't seem to find any info that might point me in the right direction.
thanks in advance
Code: $hmpc = count($_POST['pid']);
$i = 0;
while ($i <= $hmpc) {
$player = array($_POST['pid'],array($_post['gp']);
$i++;
}
$i = 0;
$x=0;
echo $hmpc;
while ($i < $hmpc) {
while ($x < $hmpc) {
echo 'Player Data: '.$player[$i][$x];
$x++;
}
$i++;
Need help with PHP/MySQL drop down menu
I need help on how I can implement a drop down menu which queries mysql database and output the available data based on price range. This feature has been used here http://www.vebra.com - I will
Does deleting the spmlog directory critical?
Hi Everyone,
insert Multiple rows into the table from that table data
Hi All,
Trouble checking SESSION cookie
I am trying to use $_SESSION cookies to verify admin privileges .I don't understand why this is not working:/*everything above here is working*/ $session = mysql_fetch_array($session_query); $type =
Comment Mod System Effects all rows...
Sorry if its confusing but here is whats going on: I have a table in a database called comments and there are alot of entries there but can manually be marked flagged with a 1. nevermind how that is
defining website tags
Hi,What would be the best way to define tags for my site, such as website title, url etc.Should I just use somethng like:$website_name = "name";or should I use arrays?Thanks
Including calander to page - will not show other months than current??
im trying to add an existaing calander onto a profile page by using Code: <?php include "diary/cal_show.php";?>which looks like this...But when i hit either arrows to move on
DB2 for z/OS, LUW, iSeries
Hello,
Just wondering what you think about my site
I am new to phpfreaks i just seen this form and thought it would be cool to see what other thought about my site, feel free to sign up an post items to see how that all works or if you dont want to
Display certain image depending on time of year
Hi, I am new to these forums and would really appreciate some advice on a piece of coding I have done.Basically what I am trying to do is on our intranet, display a different home page banner