mysql and 2 slects

donkeychoker

Hi All!

I am really struggling, wonder if someone could help.

I have 2 db tables. The first (birthdates) contains everything about a person from age to birth place, parents names, etc, all in a row. (I have 60 people...60 rows)

My second table (bd_images) contains images relating to a person in table one. This table has just 3 columns: 'id,' 'image' and 'ref'. The ref number is linked to table one's' id' column. So a person in T1 with an 'id' of 20 has images relating to them in T2 with the 'ref' number 20..

Hope that makes sense.........

I can't understand how to loop through both these tables in a single query. If I try UNION I get errors about using id problems, and if i try JOIN is says something about both tables need to have the same number of columns

Is there a way to simply have one SELECT and one WHILE LOOP?
Can I put a WHILE LOOP inside another?

Thx

bpat1434

SELECT b.*, i.image
FROM birthdays AS b
INNER JOIN bd_images AS i
    ON b.id = i.ref
ORDER BY b.id ASC

Run that query, the loop through and call it as you normally would. The image is now included with the query.

donkeychoker

many many thx.
Could you please explain it to me as i need to include the WHERE clause and i am totally lost.

thx

bpat1434

SELECT b.*, i.image
FROM birthdays AS b
INNER JOIN bd_images AS i
    ON b.id = i.ref
WHERE b.something = '$someinput'
ORDER BY b.id ASC

The INNER JOIN joins each and every row in each table together based upon the ON or USING clause. So it will join the table based upon the ID numbers in your birthdays table, and the ref number in the bd_images table.

Simple really. If you want to know more, or need more explanation: JOINS explained

donkeychoker

many thx, really appreciated.