Mysql help please

[flaminhoon]

Hi I have written this SQL query, but there is something wrong somewhere, it
crashes my server, maybe its looping somewhere. What Im trying to do is show
the number of comments (comments table) there were left an and article
(contents table) If anybody could give me a pointer I might save whats left of
my hair. Thanks in advance. Steve Here is mu query using PHPDEV apache server
php 4. MYSQL SELECT COUNT(comments.contents_id), comments.contents_id,
contents.contents_id, contents.description,
contents.image1,contents.owner,contents.dateinsert FROM contents LEFT JOIN
comments on contents.contents_id = comments.contents_id WHERE contents.isit =
'-1' GROUP BY comments.contents_id ORDER BY contents.contents_id DESC

[Michael Fesser]

.oO(flaminhoon)

>Hi I have written this SQL query, but there is something wrong somewhere, it
>crashes my server, maybe its looping somewhere.

Crashes in what way? MySQL always creates error messages if something is
wrong. Check mysql_error() if mysql_query() fails to execute the query.

What happens when you run the query directly at the MySQL prompt?

>SELECT COUNT(comments.contents_id), comments.contents_id,
>contents.contents_id, contents.description,
>contents.image1,contents.owner,contents.dateinser t FROM contents LEFT JOIN
>comments on contents.contents_id = comments.contents_id WHERE contents.isit =
>'-1' GROUP BY comments.contents_id ORDER BY contents.contents_id DESC

Of what type is contents.isit? The value looks numeric, why is it
quoted?

Micha

[flaminhoon]

There are no errors, the page just executes really slowly, it wouldnt work at
all before . this is my latest attempt at the SQL this is the page
[url]http://www.whitefriars.com/isit_list.php[/url] SELECT contents.contents_id,
contents.description, contents.isit_approved,
contents.image1,contents.owner,contents.dateinsert , COUNT(comments.contents_id)
FROM contents LEFT JOIN comments on contents.contents_id = comments.contents_id
WHERE contents.isit_approved = '-1' GROUP BY comments.contents_id,
contents.contents_id, contents.description,contents.image1,
contents.isit_approved ORDER BY contents.contents_id DESC :confused; Any ideas
anybody? Thanks Flaminhoon