i have a weired problem:
there are 3 tables:
photos (id, img)
comments (id, phid, text)
ratings (id, phid, text)
now i tried to create a query returning the amount of ratings and the amount
of comments for all images in the photo-table.
i tried it with multiple joins, but without success...
but i ended up using some CREATE TEMPORARY TABLE syntax - is there a way to
do it one-query?
CREATE TEMPORARY TABLE comments_temp
SELECT comments.id, comments.phid,
COUNT(comments.id) AS ratings
LEFT JOIN ratings ON ratings.phid=comments.phid
GROUP BY comments.phid,
COUNT(photos.id) AS comments,
LEFT JOIN comments_temp ON comments_temp.phid = photos.id
GROUP BY photos.id;
DROP TABLE comments_temp;
as said i would like to do it one-query, because it does not seem to me
being a simple and beautiful solution??
help would be warmly appretiated... thx alot
# life would be easier if i knew the source code...
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php