How to inner join two tables results on condition that either table has a like data

Question

SELECT 'club_profile.'club_name_link','players'.'player_name_link' 
FROM club_profile 
     INNER JOIN players ON 'club_profile'.'club_name_link' 
       OR 'players'.'player_name_link' 
       LIKE '%".$category_result."%' 
LIMIT 0,10");

Result I got

Parse error: syntax error, unexpected '$category' (T_VARIABLE) in C:\xampp\htdocs\scoresfield\admin\post.php on line 22

The `ON` clause should contain a relationship between columns in the two tables. You're not relating anything in `club_profile` to `players` in your query. — Barmar, Jul 29 '17 at 15:59

ScaisEdge · Answer 1 · 2017-07-29T18:38:41.573

2

You should not use single quotes for tables and columns name .. when necessary use backtics

"SELECT club_profile.club_name_link,players.player_name_link 
FROM club_profile 
     INNER JOIN players ON club_profile.club_name_link 
       OR players.player_name_link 
       LIKE concat('%','".$category_result."','%' )  
LIMIT 0,10");

( the use of $var is deprecated because can permit sqlinjection
take a look at the sql driver you are using and use parameter binding instead)

edited Jul 29 '17 at 18:38

answered Jul 29 '17 at 15:51

ScaisEdge

131,976
10
91
107

Its still giving the same response – Johnson Fashanu Jul 29 '17 at 17:34
answer updated .. let me know – ScaisEdge Jul 29 '17 at 18:38

How to inner join two tables results on condition that either table has a like data

1 Answers1