need help defining a string.

[Mark_Nordstrom]

<?
$content=file("$form_data"); 
unset($content[1]); 
$tabbed=implode("",preg_replace('%[ ]{2,}%s', "\t", $content)); 
preg_match_all("%(.*)\t(.*)\t(.*)\t(.*)%miU", $tabbed, $matches); 
echo '<table border="1"> 
         <tr> 
             <th>'.$matches[1][0].'</th> 
             <th>'.$matches[2][0].'</th> 
             <th>'.$matches[3][0].'</th> 
         </tr>'; 
for ($i=1; $i<count($matches[1]);$i++) 
  echo '<tr> 
             <td>'.$matches[1][$i].'</td> 
             <td>'.$matches[2][$i].'</td> 
             <td>'.$matches[3][$i].'</td> 
        </tr>'; 
echo '</table>';
?>

<?
$db=mysql_connect("localhost", "mflblin","1234gomfl");  

mysql_select_db("mflblin_madden",$db);  

//getting the teams's names 
$team1=$matches[2][0]; 
$team2=$matches[3][0]; 

//querying their ids 

echo $sql="SELECT 
    team_id, team_name 
FROM 
    team 
WHERE 
    team_name IN ('".$team1."', '".$team2."')"; 
$result=mysql_query($sql) or die(mysql_error()); 
while ($row=mysql_fetch_assoc($result)) 
    $teams[]=$row; 

//order them correct 
if ($teams[0]['team_name']!=$matches[2][0]) 
    list($teams[0], $teams[1])=array($teams[1], $teams[0]); 

//insert game
print_r($teams);
echo $sql='INSERT INTO game 
    SET team1='.$teams[0]['team_id'].', team2='.$teams[1]['team_id']; 
mysql_query($sql) or die(mysql_error()); 

//retrieve game_id 
$game=mysql_insert_id(); 

//insert data 
for ($i=1; $i<count($matches[2]); $i++)   

    $data[]=$matches[2][$i]; 
echo $sql='INSERT INTO result 
  (game_id, team_id, points, benchscoring, fieldgoals, fieldgoalp, threepointfg, threepointfgp, freethrows, freethrowp, rebounds, offrebounds, defrebounds, blocks, steals, assists, turnovers, fouls) 
VALUES ('.$game.', '.$teams[0]['team_id'].', '.implode(', ', $data).')';
unset($data);

//test output 
echo '<hr />'.$sql.'<p />';  

mysql_query($sql) or die(mysql_error());  

//the same for team2 
for ($i=1; $i<count($matches[3]); $i++)   

    $data[]=$matches[3][$i]; 
echo $sql='INSERT INTO result 
  (game_id, team_id, points, benchscoring, fieldgoals, fieldgoalp, threepointfg, threepointfgp, freethrows, freethrowp, rebounds, offrebounds, defrebounds, blocks, steals, assists, turnovers, fouls) 
VALUES ('.$game.', '.$teams[1]['team_id'].', '.implode(', ', $data).')';
//test output 
echo $sql.'<hr />';  

mysql_query($sql) or die(mysql_error());

//assuming $points1 are points of $teams[0]['team_id'] 
if ($points1 > $points2)  //team1 won 
{ 
  mysql_query('UPDATE team SET wins=wins+1 WHERE team_id='.$teams[0]['team_id']); 
  mysql_query('UPDATE team SET losses=losses+1 WHERE team_id='.$teams[1]['team_id']); 
} 
else //team2 won 
{ 
  mysql_query('UPDATE team SET wins=wins+1 WHERE team_id='.$teams[1]['team_id']); 
  mysql_query('UPDATE team SET losses=losses+1 WHERE team_id='.$teams[0]['team_id']); 
}

?>

You see the $points1 and 2 ?? Well I need them to mean this.

Points1=$teams[0] the number of points that team scored from the data submitted.

Points2=$teams[1] The Number of points that team scored from the data submitted

[python_q]

Okay, from what I can tell (mind you it is 3:30 in the morning), the points each team scored is the first column of each row in $data.
Therefore, $points1 = $data[0][0] and $points2 = $data[1][0]. See if this works.

[Mark_Nordstrom]

Thanks for help it works.

[Mark_Nordstrom]

Ok Guess it works but then it doesnt.

Its giving me the Bench Scoring points from the log. Its 1 line lower then the actual points any ideas ?

[python_q]

Yeah, on second look I realized that $data is unset. $data[0] is the points for each team.
So, have $points1=$data[0] before the unset($data), and $points2=$data[0] before the last conditional.

[Mark_Nordstrom]

well im lost. Maybe im puting it in the wrong place or something.

[Mark_Nordstrom]

$points1=$data[0]

Ok This does the right side of the file. If i make it a 1 it goes down 1 row. So how to i make it go left to the other side of file ?

[python_q]

Okay, where you have: for ($i=1; $i<count($matches[2]); $i++)

$data[]=$matches[2][$i];

$data apparently contains, in this order: points, benchscoring, fieldgoals, fieldgoalp, etc. So $data[0] should be points. You need to set $points1 = $data[0] before you unset($data) and you need to set $points2 =$data[0] right after the second for loop

So, the last part of your code should be like this:

//insert data 
for ($i=1; $i<count($matches[2]); $i++)    

    $data[]=$matches[2][$i];  

echo $sql='INSERT INTO result 
  (game_id, team_id, points, benchscoring, fieldgoals, fieldgoalp, threepointfg, threepointfgp, freethrows, freethrowp, rebounds, offrebounds, defrebounds, blocks, steals, assists, turnovers, fouls) 
VALUES ('.$game.', '.$teams[0]['team_id'].', '.implode(', ', $data).')';
// Set $points1 to number of points for Team 1
$points1 = $data[0];
unset($data); 

//test output 
echo '<hr />'.$sql.'<p />';   

mysql_query($sql) or die(mysql_error());   

//the same for team2 
for ($i=1; $i<count($matches[3]); $i++)    

    $data[]=$matches[3][$i];  

echo $sql='INSERT INTO result 
  (game_id, team_id, points, benchscoring, fieldgoals, fieldgoalp, threepointfg, threepointfgp, freethrows, freethrowp, rebounds, offrebounds, defrebounds, blocks, steals, assists, turnovers, fouls) 
VALUES ('.$game.', '.$teams[1]['team_id'].', '.implode(', ', $data).')';
// Set $points2 to number of points for Team 2
$points2 = $data[0];

//test output 
echo $sql.'<hr />';   

mysql_query($sql) or die(mysql_error()); 

//assuming $points1 are points of $teams[0]['team_id'] 
if ($points1 > $points2)  //team1 won 
{  

  mysql_query('UPDATE team SET wins=wins+1 WHERE team_id='.$teams[0]['team_id']);  

  mysql_query('UPDATE team SET losses=losses+1 WHERE team_id='.$teams[1]['team_id']);  

}  

else //team2 won 
{  

  mysql_query('UPDATE team SET wins=wins+1 WHERE team_id='.$teams[1]['team_id']);  

  mysql_query('UPDATE team SET losses=losses+1 WHERE team_id='.$teams[0]['team_id']);  

}

I hope this works.

[tekky]

Hey Mark 🙂 not sure if this is what we tried before... but give it ago...

<?
$content=file("$form_data"); 
unset($content[1]); 
$tabbed=implode("",preg_replace('%[ ]{2,}%s', "\t", $content)); 
preg_match_all("%(.*)\t(.*)\t(.*)\t(.*)%miU", $tabbed, $matches); 
echo '<table border="1"> 
         <tr> 
             <th>'.$matches[1][0].'</th> 
             <th>'.$matches[2][0].'</th> 
             <th>'.$matches[3][0].'</th> 
         </tr>'; 
for ($i=1; $i<count($matches[1]);$i++) 
  echo '<tr> 
             <td>'.$matches[1][$i].'</td> 
             <td>'.$matches[2][$i].'</td> 
             <td>'.$matches[3][$i].'</td> 
        </tr>'; 
echo '</table>';
?>

<?
$db=mysql_connect("localhost", "mflblin","1234gomfl");  

mysql_select_db("mflblin_madden",$db);  

//getting the teams's names 
$team1=$matches[2][0]; 
$team2=$matches[3][0]; 

//querying their ids 

echo $sql="SELECT 
    team_id, team_name 
FROM 
    team 
WHERE 
    team_name IN ('".$team1."', '".$team2."')"; 
$result=mysql_query($sql) or die(mysql_error()); 
while ($row=mysql_fetch_assoc($result)) 
    $teams[]=$row; 

//order them correct 
if ($teams[0]['team_name']!=$matches[2][0]) 
    list($teams[0], $teams[1])=array($teams[1], $teams[0]); 

//insert game
print_r($teams);
echo $sql='INSERT INTO game 
    SET team1='.$teams[0]['team_id'].', team2='.$teams[1]['team_id']; 
mysql_query($sql) or die(mysql_error()); 

//retrieve game_id 
$game=mysql_insert_id(); 

//insert data 
for ($i=1; $i<count($matches[2]); $i++)   

    $data[]=$matches[2][$i]; 
echo $sql='INSERT INTO result 
  (game_id, team_id, points, benchscoring, fieldgoals, fieldgoalp, threepointfg, threepointfgp, freethrows, freethrowp, rebounds, offrebounds, defrebounds, blocks, steals, assists, turnovers, fouls) 
VALUES ('.$game.', '.$teams[0]['team_id'].', '.implode(', ', $data).')';
$points1 = $date[0]; //line added to get points for team 1
unset($data);

//test output 
echo '<hr />'.$sql.'<p />';  

mysql_query($sql) or die(mysql_error());  

//the same for team2 
for ($i=1; $i<count($matches[3]); $i++)   

    $data[]=$matches[3][$i]; 
echo $sql='INSERT INTO result 
  (game_id, team_id, points, benchscoring, fieldgoals, fieldgoalp, threepointfg, threepointfgp, freethrows, freethrowp, rebounds, offrebounds, defrebounds, blocks, steals, assists, turnovers, fouls) 
VALUES ('.$game.', '.$teams[1]['team_id'].', '.implode(', ', $data).')';
$points2 = $data[0]; //line added to get points for team2
//test output 
echo $sql.'<hr />';  

mysql_query($sql) or die(mysql_error());

//assuming $points1 are points of $matches[2][1][0] 
if ($points1 > $points2)  //team1 won 
{ 
  mysql_query('UPDATE team SET wins=wins+1 WHERE team_id='.$teams[0]['team_id']); 
  mysql_query('UPDATE team SET losses=losses+1 WHERE team_id='.$teams[1]['team_id']); 
} 
else //team2 won 
{ 
  mysql_query('UPDATE team SET wins=wins+1 WHERE team_id='.$teams[1]['team_id']); 
  mysql_query('UPDATE team SET losses=losses+1 WHERE team_id='.$teams[0]['team_id']); 
}

?>

[Mark_Nordstrom]

it seems to be working now. Thanks.