Parse error: syntax error, unexpected T_STRING

arighttouch1985

i am getting the following error on my site:

Parse error: syntax error, unexpected T_STRING in /students_web/www_students/ece40465/login.php on line 19

i have supplied the login.php script, line 19 = $query = “SELECT * FROM users where username=’$username’ and password=’$password’”;

any help would be much appreciated.

<?php

//Database Information

$dbhost = "#####";
$dbname = "#####";
$dbuser = "######";
$dbpass = "######";

//Connect to database

mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());

session_start();
$username = $_POST[‘username’];
$password = md5($_POST[‘password’]);

$query = “SELECT * FROM users where username=’$username’ and password=’$password’”;

$result = mysql_query($query);

if (mysql_num_rows($result) != 1) {
$error = “Bad Login”;
    include “login.html”;

} else {
    $_SESSION[‘username’] = “$username”;
    include “memberspage.php”;
}

?>

YAOMK

why are you using back-ticks to define strings in php? change it where present in your code. Back-ticks ` are only appropriate around mysql reserved words like your password column, in which case they should be around the column name not the password variable.

NogDog

As YAOMK alludes to, it appears whatever editor you are using is applying "smart quotes" to your text. If so, you either need to use a different editor, or else turn off that "smart quote" feature in your editor so that you only use "straight" (or "non-directional") quotes. For example, lines like this...

$username = $_POST[‘username’];
$password = md5($_POST[‘password’]);

$query = “SELECT * FROM users where username=’$username’ and password=’$password’”;

...need to be changed to...

$username = $_POST['username'];
$password = md5($_POST['password']);

$query = "SELECT * FROM users where username='$username' and password='$password'";

I would suggest you use an editor such as Notepad++ or HTML-Kit (or at least just plain old Notepad in Windows) rather than something like MS Word or Wordpad, which are designed for desktop publishing rather than plain text editing.