Where do i put this little bit

[npsari]

I have this little php code

in which, i join two tables

 

$qX = "SELECT c.category_name, c.category_id, c.category_info, t.topic_category_id
FROM category c
LEFT JOIN topic t
ON t.topic_category_id = c.category_id
ORDER BY c.category_id ASC";

 

I want to add this bit

 

COUNT(t.topic_category_id) as CNT

 

Where do i put it in the above code

 

Wherever i add it, the query does not work completely

 

i tried for example

 

$qX = "SELECT c.category_name, c.category_id, c.category_info, t.topic_category_id
COUNT(t.topic_category_id) as CNT
FROM category c
LEFT JOIN topic t
ON t.topic_category_id = c.category_id
ORDER BY c.category_id ASC";

 

It doesnt work

[soycharliente]

That's because you need a comma right before it to separate it from the previous select.

 

$qX = "SELECT c.category_name, c.category_id, c.category_info, t.topic_category_id, 
COUNT(t.topic_category_id) as CNT
FROM category c
LEFT JOIN topic t
ON t.topic_category_id = c.category_id
ORDER BY c.category_id ASC";

[npsari]

i tried that (adding the comma)

however, everything dissapeards!

[soycharliente]

I only saw that one problem (this missing comma). I don't know enough about JOIN to be able to help.