parse error, unexpected T_STRING

smoe123

Hi,

I've been getting the following message when I run my php page:

Parse error: parse error, unexpected T_STRING error on line 4

The following is top few lines in my script. Look at the 4th and 5th line.

include("inc/config.php");
$connection = mysql_connect($hostname, $user, $pass) or die ("Unable to connect!");
$query = SELECT * FROM clients WHERE name = ('$name') AND password = PASSWORD('$password');
$result = mysql_db_query($database, $query, $connection);
if (mysql_num_rows($result) == 1)

I am very new to this PHP stuff. It took me 5 hours just to figure out a small quotation problem.

I appreciate the help.

AceE

PASSWORD('$password');

never seen that before, is that your own custom function? or did I miss a page on php.net?

oh! and:

$query = SELECT * FROM clients WHERE name = ('$name') AND password = PASSWORD('$password');

it's a string variable, so it should be quoted eg.

$query = "SELECT * FROM clients WHERE name = ('$name') AND password = PASSWORD('$password')";

LordShryku

You need quotes for your query variable.

$query = "SELECT * FROM clients WHERE name = '$name' AND password = PASSWORD('$password')";

pjleonhardt

or if you didnt make a custom function PASSWORD()
and you have a value to the variable $password you should be find doing..

$query = "SELECT * FROM clients WHERE name = '$name' AND password = '$password'";

Like i said, thats only if youre not passing $password through the function PASSWORD() (which saying youre really new to PHP i dont think you would have made a custom function, but its possible)