date update

[Platoon_Leader]

I am trying to show on a ladder system when a player last played, can get date up date when they report a match.

$lastplayed = date("M d, Y");

$lastplayed = $row["lastplayed"];

$sql = "UPDATE $playerstable lastplayed";

I have setup all the fields in the database and the instailed last played date is set for the date they join the league, would I need to clear the old date first and if so how?

[planetsim]

Are you just trying to update when the user last played. What you have done it right except

update is this

UPDATE tbl_name SET feild_name = $feildname WHERE feildname='$feildname'

[Platoon_Leader]

It's still not updating the lastplayed field with the new date🙁

[Platoon_Leader]

I change the line to what you posted but still no update.

$sql = "UPDATE $playerstable SET lastplayed = $lastplayed WHERE lastplayed='$lastplayed'";

[Rodders]

Answer these questions:

1) How do you know which row in the table to update? Is it one row per player? If so, which player are you trying to update? Does he have an ID?

2) Where are you getting the new 'lastplayed' date from?

Can you list the table's fields, and indicate what the keys are?

[Platoon_Leader]

Heres the players fields

CREATE TABLE test_players (
  player_id int(10) NOT NULL auto_increment,
  name varchar(40) NOT NULL default '',
  joined varchar(20) NOT NULL default '',
  passworddb varchar(10) default NULL,
  mail varchar(50) default NULL,
  url varchar(255) NOT NULL default '',
  icq varchar(15) default NULL,
  aim varchar(40) default NULL,
  country varchar(40) default NULL,
  slogo varchar(255) NOT NULL default '',
  games int(10) default '0',
  wins int(10) default '0',
  losses int(10) default '0',
  points int(10) default '1200',
  totalwins int(10) default '0',
  totallosses int(10) default '0',
  totalpoints int(10) default '1200',
  totalgames int(10) default '0',
  penalties int(10) default '0',
  streakwins int(10) default '0',
  streaklosses int(10) default '0',
  lastplayed varchar(20) NOT NULL default '',
  PRIMARY KEY  (player_id),
  UNIQUE KEY name (name)
) TYPE=MyISAM;

The field that i want updated is the lastplayed field with the date a match is reported.

All players have an ID and the lastplayed date would come from the last date a match was reported for the player.

Heres the code i hope this helps you better understand what I'm trying to do.

<?php
require('variables.php');
require('variablesdb.php');
require('meta.php');
require('header.php');
require('leftmenu.php');
require('main1.php');
?>
<p align="center" class="text"><font size="5" color="#FFFFFF">Report a Match</font></p>
<p align="left" class="text">
<?php

   $date = date("M d, Y");
   $lastplayed = date("M d, Y");

if ($submit) {
   $db = mysql_connect($databaseserver, $databaseuser, $databasepass);
   mysql_select_db($databasename,$db);
      if ($report == "winner") {
      $reportname = "$winnername";
      }
      else {
      $reportname = "$losername";
      }
   $sql="SELECT * FROM $playerstable WHERE name = '$reportname'";
   $result=mysql_query($sql,$db);
   $row = mysql_fetch_array($result);
   $name = $row["name"];
   $passworddb = $row["passworddb"];

  if ($passworddb == "$passworduser") {

    $db = mysql_connect($databaseserver, $databaseuser, $databasepass);
    mysql_select_db($databasename,$db);
    $sql="SELECT * FROM $gamestable WHERE winner = '$winnername' and loser = '$losername' and comments= '$comments' and date = '$date'";
    $result=mysql_query($sql,$db);
    $oneway = mysql_num_rows($result);
    $db = mysql_connect($databaseserver, $databaseuser, $databasepass);
    mysql_select_db($databasename,$db);
    $sql="SELECT * FROM $gamestable WHERE winner = '$losername' and loser = '$winnername' and comments= '$comments' and date = '$date'";
    $result=mysql_query($sql,$db);
    $otherway = mysql_num_rows($result);
    $num = $oneway + $otherway;
    if ($num < $gamesmaxday) {
        if ($winnername == $losername) {
        echo "You can't play against yourself";
        }
        else {
  // process form
  $db = mysql_connect($databaseserver, $databaseuser, $databasepass);
  mysql_select_db($databasename,$db);
//Point Sytem 
$loserpointsvar1 = mysql_query ("SELECT points FROM $playerstable WHERE name = '$losername'"); 
$winnerpointsvar1 = mysql_query ("SELECT points FROM $playerstable WHERE name = '$winnername'"); 
$loserpointsvar2=mysql_fetch_row($loserpointsvar1); 
$winnerpointsvar2=mysql_fetch_row($winnerpointsvar1); 
$loserpoints=$loserpointsvar2[0]; 
$winnerpoints=$winnerpointsvar2[0]; 
$Kvalue = "32"; // This is the tournament value. It should be between 8 and 40, depending on how you want it - you could have different times as different values, or special weekends ect. 
$winnerscoringpoints = "1"; 
$loserscoringpoints = "0"; 
$drawscoringpoints = "0.5"; 
$winner1 = ($loserpoints - $winnerpoints); 
$winner2 = ($winner1/400); 
$winner3 = ($winner2 * (-1)); 
$winner4 = ( pow(10,$winner2) ); 
$winner5 = ($winner4 + 1); 
$winnerwinprob = (1/$winner5); 
$winnerrating1 = ($winnerscoringpoints - $winnerwinprob); 
$winnerrating2 = ($Kvalue * $winnerrating1); 
$pointswin = round($winnerrating2); 
$loser1 = ($winnerpoints - $loserpoints); 
$loser2 = ($loser1/400); 
$loser3 = ($loser2 * (-1)); 
$loser4 = ( pow(10,$loser2) ); 
$loser5 = ($loser4 + 1); 
$loserwinprob = (1/$loser5); 
$loserrating1 = ($loserscoringpoints - $loserwinprob); 
$loserrating2 = ($Kvalue * $loserrating1); 
$pointsloss = round($loserrating2); 

$lastplayed = $row["lastplayed"];

  $sql = "UPDATE $playerstable SET wins = wins, losses= losses + 1, totalwins = totalwins, totallosses= totallosses + 1, points = points + $pointsloss, totalpoints = totalpoints + $pointsloss, games = games + 1, totalgames = totalgames + 1, streakwins = 0, streaklosses = streaklosses + 1 WHERE name='$losername'";
  $result = mysql_query($sql);
  $sql = "UPDATE $playerstable SET wins = wins + 1, losses= losses, totalwins = totalwins + 1, totallosses= totallosses, points = points + $pointswin, totalpoints = totalpoints + $pointswin, games = games + 1, totalgames = totalgames + 1, streakwins = streakwins + 1, streaklosses = 0 WHERE name='$winnername'";
  $result = mysql_query($sql);
  $sql = "UPDATE $playerstable SET lastplayed = $lastplayed WHERE lastplayed='$lastplayed'";
  $result = mysql_query($sql);
  $sql = "INSERT INTO $gamestable (winner, loser, comments, date) VALUES ('$winnername', '$losername', '$comments', '$date')";
  $result = mysql_query($sql);

  echo "Thank you! Information entered.";
        }
    }
    else {
    echo "You can't play more than $gamesmaxday games per day against the same player!";
    }
  }
  else {
  echo "Incorrect password. Try again.";
  }
} 
else {
// display form
?>

[Rodders]

Well, it looks like your UPDATE is pointless.

You do this.....

$sql="SELECT * FROM $playerstable WHERE name = '$reportname'";
   $result=mysql_query($sql,$db);
   $row = mysql_fetch_array($result);

...and later this.....

$sql = "UPDATE $playerstable SET lastplayed = $lastplayed WHERE lastplayed='$lastplayed'";
      $result = mysql_query($sql);

So this gets the lastplayed date from $playerstable, and then later you try to UPDATE the value with the one you just got with the SELECT.

Two things:
1) You must have a way of finding the latest game date that the player was involved in, i.e. when did the player last play?

2) Your UPDATE statement isn't right. You should get the player_id or name that you want to update. Then it will look like this

$sql = "UPDATE $playerstable SET lastplayed = '$lastplayed' WHERE player_id = '$player_id'"
$result = mysql_query($sql) or die(echo 'SQL: ' . $sql);

I've added the 'or die' so you can see the SQL if it fails, but that's up to you.

[Platoon_Leader]

Thanks for you help I now have the lastplayed field updating.

$sql = "UPDATE $playerstable SET lastplayed = '$lastplayed' WHERE name = '$losername'";
      $result = mysql_query($sql);
      $sql = "UPDATE $playerstable SET lastplayed = '$lastplayed' WHERE name = '$winnername'";
      $result = mysql_query($sql);