[RESOLVED] NO error - but returning no result

[madwormer2]

Basically I have two tables, one for news, and one for results.

I am doing a

SELECT * FROM `news` AS t1, `news_comments` AS t2 WHERE t1.id = t2.newsid ORDER BY t1.date DESC, t1.id DESC, t2.com_datetime DESC

query, and to start off with I already had comments I had inserted manually, it worked PERFECTLY! That was until of course, I deleted all of the comments, then I get absolutely no result from this query.

Is there any way to get round this, where it still returns results even if there are no comments. :quiet:

Cheers in advance (I know its probably something really easy 😉)

[mystrymaster]

IF there are no comments associated to each news story you will get nothing returned you need to look up inner join on mysql that should help you.

[madwormer2]

Ah, inner join, gotcha.

😉

[madwormer2]

Just to let you know, it was a LEFT JOIN query I was looking for, and NOT INNER JOIN as inner join will not produce any results when the join cannot happen, but left join will.

😛

More knowledge points to me!

[mystrymaster]

cool gotcha - I haven't needed to use a join like this yet

Glad it worked out

Mark thread resolved