Query/PHP error

bokerfest

I am doing this left join query but I keep on getting this error:

Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING' in serverURL/test2.php ------ Line Error is pointing to is tasks.tasksUSER='$_SESSION['valid_user']' ";

Anyone have any ideas?

$query = " SELECT * 
				FROM 
				tasks LEFT JOIN users ON
				(tasks.* = users.usersID) 
				WHERE 
				tasks.tasksUSER='$_SESSION['valid_user']' "; 
				$result = mysql_query ($query) or die("mysql Error: ".mysql_error());

				echo ($result) ;

sidney

the query sees the single quotes and interprts the first two as the value

try it as below

 $query = " SELECT * 
                FROM  

                tasks LEFT JOIN users ON 
                (tasks.* = users.usersID) 
                WHERE  

                tasks.tasksUSER='".$_SESSION['valid_user']."' ";  

                $result = mysql_query ($query) or die("mysql Error: ".mysql_error()); 

                echo ($result) ;

bokerfest

That worked. I is now inserting the session varirable like i want but now it comes up with this mysql error. I am not sure what it is confusing. It seems to not like my

mySQL Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' = users.usersID) WHERE tasks.tasksUSER='imminkb'' a

(tasks.* = users.usersID)

line Is there some other way to put that other than the way I have it?

Thanks

Weedpacket

Well, what (tasks.* = users.usersID) is asking for is "every record where all the fields is equal to users.usersID" - bad grammar and all. Presumably there's a field in the tasks table that contains user IDs, and you should be specifying that.