[RESOLVED] Joint Count - MySQL

[kikki]

Hey guys,
I wonder how to do the joint count, I've never done this before, I really need help doing this.. any help would be appreciated.

I've got 2 tables as follows;

table1 = id, Qsite, Qkey, Qlinks, Qlocation, ...
table2 = id, Qlink, Qkey

I need to count all the "table2" entries WHERE (table1.Qkey=table2.Qkey) AND (table1.Qlocation='$mylocation')

this is the query I gave a try, but doesn't seem to work at all.. whats wrong with it?

$query = "SELECT p.id, p.Qkey, p.Qlocation, COUNT(c.id) AS XAmount 
  FROM table1 p
  LEFT JOIN table2 c ON p.Qkey = c.Qkey
  WHERE p.`Qlocation`='$location'
  GROUP BY p.id
  ORDER BY p.id DESC";

TIA!

[bradgrafelman]

Does MySQL return an error message, and, if so, what is it?

[kikki]

bradgrafelman wrote:

Does MySQL return an error message, and, if so, what is it?

thanks for the reply bradgrafelman,
No it doesn't print out anything... even mysql_error() doesn't show anything..

[kikki]

Actually there is a query that I ran before this query.... but after renaming the variables it does work... $query1, $query2, $row1, $row2 etc..

thanks for the help anyway.. 🙂