MySql Select data from multiple tables

Question

This is my current query:

SELECT * FROM images T 
JOIN boxes_items T2 
ON T.ITEM_ID = T2.ITEM_PARENT_ID 
WHERE T2.ITEM_ID = '$image_id'

I also need to Select all from a table named 'boxes' where the box_id is taken from boxes_items.
How to add this to the query?

Your description isn't clear enough, can't tell whether you need a UNION or another JOIN. Can you add sample data and the desired result? — Barmar
– Barmar, Commented Jul 8, 2013 at 18:33
@Barmar I think I need another Join - I need to Select all from Another table named "Boxes" where the box_id = box_id collected from "boxes_items" WHERE T2.ITEM_ID = '$image_id' — bushdiver
– bushdiver, Commented Jul 8, 2013 at 18:35

echo_Me · Accepted Answer · 2013-07-08 18:40:09Z

3

try this

  SELECT T.* , T2.* , T3.* FROM images T 
  JOIN boxes_items T2  ON T.ITEM_ID = T2.ITEM_PARENT_ID 
  JOIN boxes  T3 ON T3.box_id = t2.box_id
  WHERE T2.ITEM_ID = '$image_id'

edited Jul 8, 2013 at 18:40

answered Jul 8, 2013 at 18:33

echo_Me

37.2k5 gold badges62 silver badges81 bronze badges

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

4 Comments

Barmar Over a year ago

What's the difference between this and the original query? Where is the table boxes?

echo_Me Over a year ago

@Barmar you have good eyes barmar :) , can you sell me one :) ?

bushdiver Over a year ago

How to differentiate between rows after results? $row['T.something'] ?

echo_Me Over a year ago

call them like that : $row['something'] , and columns if they have same name give them a different aliases AS ... and then call them as normal

Mahmoud Gamal · Accepted Answer · 2013-07-08 18:33:08Z

2

SELECT * 
FROM images T 
JOIN boxes_items T2 ON T.ITEM_ID = T2.ITEM_PARENT_ID 
JOIN boxes AS b ON b.box_id = t2.box_id
WHERE T2.ITEM_ID = '$image_id'

answered Jul 8, 2013 at 18:33

Mahmoud Gamal

80.2k18 gold badges143 silver badges168 bronze badges

Comments

waka · Accepted Answer · 2013-07-08 18:34:53Z

1

You really shouldn't use *, it can get you into more trouble than it is worth. Especially since you have more than one table in your query.

Anyway:

Select T.*, T2.*, T3.*
from images T
join boxes_items T2 on T.ITEM_ID = T2.ITEM_PARENT_ID
join boxes T3 on T3.box_id = T2.box_id
WHERE T2.ITEM_ID = '$image_id'

answered Jul 8, 2013 at 18:34

waka

3,4459 gold badges38 silver badges54 bronze badges

2 Comments

bushdiver Over a year ago

I think this will do it, but how do I differentiate between the rows when assigning variables? using: $result = mysql_query($query); while ($row = mysql_fetch_array($result)) { }

waka Over a year ago

@bushdiver: You can differentiate between rows using the index of the rows. Usually this index is zero based, meaning that the first row has the index 0, the second index 1, etc.

Collectives™ on Stack Overflow

MySql Select data from multiple tables

3 Answers 3

4 Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related