Hello,
I'm having a bit of a problem updating a table from a perl script.
Basically, I'm trying to calculate standings from games where scores are
kept in another table. I have queries which calculate the wins losses,
etc... and they work fine. I know they work because I inserted a print
statement right before my update query and I see all of the calculated
fields.
Following the print statement is my query to update the standings table
below. No matter what I seem to do, I can not get it to insert the data
into the table. I have the perl script running with -w and get no error
messages - just the output from the print statement.
print "$team_name $total_wins - $total_losses - $total_ties
($total_games)<br>\n";
$sql_query = "update $standings_table set ";
$sql_query .= "total_games = $total_games ";
$sql_query .= ", total_wins = $total_wins ";
$sql_query .= ", total_losses = $total_losses ";
$sql_query .= ", total_ties = $total_ties ";
$sql_query .= "where team='$team_name'";
I have tried entering data directly from the command line and the following
worked fine
mysql> update standings_table set
total_games=8,total_wins=5,total_losses=3,total_ties=0 where team =
'LaJollaPinto';
The $standings_table exists and there are records in it for each team in
the league. A show columns from the standings table results in
+--------------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+----------+------+-----+---------+-------+
| team | char(64) | | PRI | | |
| total_games | int(4) | YES | | NULL | |
| total_wins | int(4) | YES | | NULL | |
| total_losses | int(4) | YES | | NULL | |
| total_ties | int(4) | YES | | NULL | |
+--------------+----------+------+-----+---------+-------+
I have also tried using replace with the following code, but that didn't
work either.
$sql_query = "replace into $standings_table ";
$sql_query .= "where team = '$team_name' ";
$sql_query .= "(total_games,total_wins,total_ties,total_losses) ";
$sql_query .= "values ($total_games,$total_wins,$total_ties,$total_losses)";
Does anyone have any ideas what I might be missing?
Jerry P
