Help with My Code!

[spike_132000]

Hey there, I am making a PSP Security Website, I have this Code, but I get an unexpected T_VARIABLE ERROR on line 43. here is the full code


[code]<?php
//MEMBER SCREEN
include '../connect.php';
session_start();
?>
<center>



</center><br><br>
<link rel="stylesheet" href="../style.css" type="text/css">

<?php
$username=$_GET['user'];
   
    $userstats="SELECT * from users where username='$username'";
    $userstats2=mysql_query($userstats) or die("Could not get user stats");
    $userstats3=mysql_fetch_array($userstats2);
    $name=$userstats3['name'];
$ip = $_SERVER['REMOTE_ADDR'];

    $ip1=$userstats3['ip1'];
    $ip2=$userstats3['ip2'];
    $ip3=$userstats3['ip3'];
    $ip4=$userstats3['ip4'];
    $ip5=$userstats3['ip5'];
$date1=$userstats3['date1'];
$date2=$userstats3['date2'];
$date3=$userstats3['date3'];
$date4=$userstats3['date4'];
$date5=$userstats3['date5'];
$ip5=$ip4;
$ip4=$ip3;
$ip3=$ip2;
$ip2=$ip1;
$ip1=$ip;
$date5=$date4;
$date4=$date3;
$date3=$date2;
$date2=$date1;
$date1=date("d F Y")

      $SQL = "UPDATE users set ip1='$ip1',date1='$date1',ip2='$ip2',date2='$date2',ip3='$ip3',date3='$date3',ip4='$ip4',date4='$sate4',ip5='$ip5',date5='$date5' where username='$username'";
mysql_query($SQL) or die ("Sorry, but the service in unnavailable at the moment!")
?>[/code]

I don't understand what is wrong![code][/code]

[spike_132000]

I have changed the $sate4 to $date4 but the error still appears!

[HuggieBear]

Try a semicolon after this line:

[code=php:0]date1=date("d F Y")[/code]

Regards
Huggie

[JasonLewis]

damn, you beat me huggie. :) i to noticed that :P lol

[spike_132000]

I realised it now! Thanks Alot!!!

[kenrbnsn]

Missing a semi-colon on the first and third lines of this three line set:

[code]<?php
$date1=date("d F Y")
$SQL = "UPDATE users set ip1='$ip1',date1='$date1',ip2='$ip2',date2='$date2',ip3='$ip3',date3='$date3',ip4='$ip4',date4='$sate4',ip5='$ip5',date5='$date5' where username='$username'";
mysql_query($SQL) or die ("Sorry, but the service in unnavailable at the moment!")
?>[/code]

Ken