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++;
New to Arrays
Hi I am new to PHP (a week and a half now) and I am just beginning to read about arrays. I understand simple arrays, associative arrays, and multidimensional arrays also. The book I am reading
user administration
Dear @all,
DOMDocument parsing
Hello, I am parsing an xml file from an API which I have converted into a DOMDocument in php. This is mostly fine but one problem I have is when I do this:Code:
Need Help with a query
Hello, For some reason I am just not getting the right answer when I do this query and not quite sure why? $runinposition = mysql_query("SELECT * FROM bb_off WHERE user='$user' AND test1='test1'
passing an array of objects after submit
How do I do this? This is what I have tried and it is not working.<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"><input
Inserting Data into a MS Access DB using PHP.
As part of my uni course I am doing a placement at a company whom want me to create a client zone for their website.Basically, they want me to create the code to get data from a MS Access db and
Date help - fetch dates for Mondays between xxx and yyy?
Does anyone know the best way to do this? I have two dates, say:2010-01-26 and 2010-05-30and I want to return the dates of all the Mondays between them:2010-02-012010-02-082010-02-15....etc.Thanks
Pipe email to PHP - get mail adress from MySQL - send?
Hi all,this is the challenge:1) Our faculty at the college where I'm employed includes quite a bit of freelancers that don't check the college mailbox quite as often as the administration would
A WBS element with the name XXX already exists in version FREI_VERSION
Hi.
Cursor statement failed with errors
Following statement failed with the errors.