error message help

Dai · July 1st, 2003, 09:29 AM

I'm getting the following error message:

Parse error: parse error, unexpected T_VARIABLE in C:\FoxServ\www\my_sites\login.php on line 12

I've had a look in the manual but can't find a reference to T_variable. Any ideas on how to fix this error.

here are the two scripts:

dbconn.php
<?php
$host = "localhost";
$user = "Dai";
$password = "xxxxxx";
$dbname = "mysites";

$link = mysql_connect($host,$user,$pass);
mysql_select_db($dbname, $link);
?>

login.php
<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Title here!</title>
</head>
<body>
<?php
include "dbconn.php";
if (isset($submit))
     {
        $query = "SELECT * FROM login WHERE name = '$name' AND password = '$password'"
        $result = mysql_query($query);
        $isAuth = false;
         while ($row = mysql_fetch_array ($result))
             {
               if ($row['name']=== $name)
                 {
                    $isAuth = true;
                    session_start();
                    session_register('name');
                 }
              }
                     if ($isAuth)
                       {
                          echo "Logged in successfull";
                          echo "<a href=input.php>go to the site list</a>";
                       }
                       else
                           {
                              echo "Wrong username or password try again";
                           }

?>
</body>
</html>

What ever makes life easy

natmaster · July 1st, 2003, 12:44 PM

this is a common problem. i get that kind of error when i accidently miss a semicolon or $ on a variable. it just means that your syntax is wrong.

in your case, on line 11, you missed a semicolon
($query = "SELECT * FROM login WHERE name = '$name' AND password = '$password'")
meaning the line after it would get confused. so with semicolon problems, it always tells you the line after it had problems

----------------------------
http://aeonofdarkness.com