Hey all,
I got this massive query, which I hope you'll be able to understand:
SELECT diary.id, diary.thedate, diary.topic, diary.entry,
count(comments.id) AS comments FROM diary, comments WHERE
diary.month='$month' AND diary.id = comments.id GROUP BY comments.id
ORDER BY diary.id DESC "
Basically what I've done is made a diary table, and allowed people to
comment on each diary entry, with the comments stored in a seperate
comments table. What i'm doing there is getting the diary entry, plus
the number of comments posted for that entry.
Now the problem is that this query only displays entries from the
diary table when a comment is added for that entry, otherwise it
comes up with a blank, because (diary.id = comments.id) isn't true.
Now, is there a way to make sure that it displays all diary entries
anyway? because if i remove that check (diary.id = comments.id) -
then all the numbers come up messed up.
Thanks
Sunny
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
