PHP SQL Request - Query 2 tables, for results on one query

Question

I need to query the database to pull all cars that a particular user likes.

I know that user_id is 1

Then I have 2 tables. 1 contains all the cars ... id and description and table 2 contains the likes.

Table 1 has a list if cars and these fields:

car_id
car_name,
car_description


Table 2 has what cars I like and these fields:

user_id
car_id
likes (1 or 0)

So I need to pull out only the records that user 1 likes from Table 2 but only the ones he likes

What SQL query would I need to do for that?

Justin · Accepted Answer · 2013-06-07 10:54:58Z

2

SELECT * FROM table1 as t0
LEFT JOIN table2 as t1 on t0.car_id = t1.car_id
WHERE t1.likes = 1

edited Jun 7, 2013 at 10:54

Justin

9,7336 gold badges39 silver badges49 bronze badges

answered Jun 7, 2013 at 10:53

Modestas Stankevičius

14410 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user2401931 · Accepted Answer · 2013-06-07 10:54:47Z

1

Try this

SELECT * FROM table1 as t1 LEFT JOIN table2 as t2 on t1.car_id = t2.car_id WHERE t2.user_id = $user_id

answered Jun 7, 2013 at 10:54

user2401931

Comments

Yogesh Suthar · Accepted Answer · 2013-06-07 10:55:18Z

0

Try this query

SELECT t1.*,t2.*
FROM tbl1 t1,tbl2 t2
WHERE likes = 1 AND user_id = 1 AND t1.car_id = t2.car_id

answered Jun 7, 2013 at 10:55

Yogesh Suthar

30.5k18 gold badges75 silver badges100 bronze badges

Collectives™ on Stack Overflow

PHP SQL Request - Query 2 tables, for results on one query

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related