join mysql query

Question

I have this query which is working fine:

$query = "SELECT adafruit_articles.id, adafruit_articles.title, adafruit_articles.timestamp  FROM adafruit_articles WHERE MONTH(timestamp)='$m' LIMIT 5";

I also have another database called adafruit_images that has the name of the image(s) for each article (some articles have no image, some have more).

The structure looks like this:

id  articleid   image

I want to combine the query from above that it also grabs the images. I'm only not that good in mysql so i was hoping someone could help.

you have examples in mysql documentation: dev.mysql.com/doc/refman/5.0/en/join.html — ZiTAL
– ZiTAL, Commented Jun 10, 2012 at 9:53

Choo · Accepted Answer · 2012-06-10 09:52:44Z

1

SELECT adafruit_articles.id, adafruit_articles.title, adafruit_articles.timestamp
FROM adafruit_articles
LEFT OUTER JOIN adafruit_images ON adafruit_images.articleid = adafruit_articles.id
WHERE MONTH(timestamp)='$m'
LIMIT 5

answered Jun 10, 2012 at 9:52

Choo

2332 silver badges8 bronze badges

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

2 Comments

Choo Over a year ago

It should work, you are probably doing something wrong, but query is correct. Are you trying this in your php application or mysql console?

Choo Over a year ago

Then you have mistake while outputting related rows, can't tell more without your code.

roev · Accepted Answer · 2012-06-10 09:54:46Z

1

It should look something like this:

SELECT adafruit_articles.id, adafruit_articles.title, adafruit_articles.timestamp
FROM adafruit_articles 
JOIN adafruit_images
ON adafruit_images.articleid = adafruit_articles.id
WHERE MONTH(timestamp)='$m' 
LIMIT 5

answered Jun 10, 2012 at 9:54

roev

1,2972 gold badges20 silver badges29 bronze badges

Collectives™ on Stack Overflow

join mysql query

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related