Inner join not working.. shows Parse error: syntax error, unexpected '=' in

Question

I am writing an Inner Join to get data from two related tables:

table 1: user

table 2: search_queries.

I got this error: Parse error: syntax error, unexpected '=' in .... on line 137

Here is the inner Join I am writing on like 137:

ssql = SELECT fname,sname FROM user INNER JOIN search_queries ON(user.id = search_queries.id);

Kindly help and let know where I might be getting it wrong.

Answer 1

This is a PHP error. Put SQL string in quotes:

$sql = "SELECT fname, sname FROM user INNER JOIN search_queries ON user.id = search_queries.id";

Answer 2

Its look like php error so you need to do like below:-

$ssql = "SELECT fname,sname FROM `user` INNER JOIN search_queries WHERE user.id = search_queries.id";

OR

$ssql = "SELECT fname,sname FROM `user` INNER JOIN search_queries ON user.id = search_queries.id";

OR () will ok also:-

 $ssql = "SELECT fname,sname FROM `user` INNER JOIN search_queries ON (user.id = search_queries.id)";

Answer 3

Remove brackets :

SELECT fname,sname 
FROM user 
INNER JOIN search_queries ON user.id = search_queries.id ;