0

I have two separate pages. One page I'm using some UPDATE queries and the second page uses an INSERT query. Neither are updating my database. I can read the database from php, but not update it. Is my syntax correct? I know I can make it more efficiant, but I just want something updating for now.

include ("teamheader.php");
$weeksubmit = $_POST['weeksubmit'];
$awaysubmit = $_POST['awaywinssubmit'];
$homesubmit = $_POST['homewinssubmit'];
$awayteamsubmit = $_POST['awaypost'];
$today = date("Y/m/d");
$firstname = $_SESSION['SESS_FIRST_NAME'];
$lastname = $_SESSION['SESS_LAST_NAME'];

mysql_query("UPDATE OCSchedule SET AwayWins='$awaysubmit' WHERE Week='$weeksubmit' AND AwayTeam='$awayteamsubmit'");
mysql_query("UPDATE OCSchedule SET HomeWins='$homesubmit' WHERE Week='$weeksubmit' AND AwayTeam='$awayteamsubmit'");
mysql_query("UPDATE OCSchedule SET Updated='$today' WHERE Week='$weeksubmit' AND AwayTeam='$awayteamsubmit'");
mysql_query("UPDATE OCSchedule SET UpdatedBy='$firstname' WHERE Week='$weeksubmit' AND AwayTeam='$awayteamsubmit'");

Here's an insert query.

if ($TeamBPlayers[$insertcounter] != 0)
{
	  mysql_query("INSERT INTO OCNews (Story, PlayerID, TeamID, NewTeamID, TradeFlag, NewsBox, EOYFlag)
	  VALUES ($insertstory, $TeamBPlayers[$insertcounter], $TeamB, $TeamA, 1, $Comments, $TeamBEOY[$insertcounter])");
}

Thoughts?

2
Contributors
2
Replies
3
Views
6 Years
Discussion Span
Last Post by chrishea
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.