CODEWITHSUNDEEP
mysqljoininner-join
Miki Liki
Miki Liki

Reputation: 47

Joining 3 tables in PHP query

Alright so for some reason I cant join 3 tables properly in with PHP and MySQL. My query worked with 2 but with 3 it wont.

select users.username,
    users.ID,
    users.currentTime,
    users.gender,
    user_ranks.likes as likes,
    user_ranks.disslikes as diss,
    profiles.img_url as URL
from users
inner join profiles,
    user_ranks on users.ID = profiles.userID LIMIT 1

Upvotes: 1

Views: 2334

Answers (4)

Bailey Granam
Bailey Granam

Reputation: 1

SELECT users.username,
    users.ID,
    users.currentTime,
    users.gender,
    user_ranks.likes as likes,
    user_ranks.disslikes as diss,
    profiles.img_url as URL
FROM users 
INNER JOIN profiles
    on users.ID = profiles.userID
INNER JOIN user_ranks
    on user_ranks.ID = profiles.userID
LIMIT 1

Upvotes: 0

Marco
Marco

Reputation: 587

You need to do a join for each of the tables. for Example:

select users.username,
users.ID,
users.currentTime,
users.gender,
user_ranks.likes as likes,
user_ranks.disslikes as diss,
profiles.img_url as URL from users 
inner join profiles on users.ID = profiles.userID 
inner join user_ranks on users.ID= user_ranks.ID LIMIT 1

Upvotes: 0

etcz0ne
etcz0ne

Reputation: 1432

SELECT 
    users.username,
    users.ID,
    users.currentTime,
    users.gender,
    user_ranks.likes as likes,
    user_ranks.disslikes as diss,
    profiles.img_url as URL
FROM users
INNER JOIN profiles ON users.ID = profiles.userID 
INNER JOIN tbl_3 ON users.col = tbl_3.fk
LIMIT 1

Upvotes: 0

wogsland
wogsland

Reputation: 9508

You need to join both tables with an ON clause:

select users.username,
    users.ID,
    users.currentTime,
    users.gender,
    user_ranks.likes as likes,
    user_ranks.disslikes as diss,
    profiles.img_url as URL
from users
inner join profiles on users.ID = profiles.userID
inner join user_ranks on user_ranks.ID = profiles.userID 
LIMIT 1

Upvotes: 2

Related Questions