Is there any way to do this?

psycorpse

I am trying to run a query that will have a count field and it will group on an id. However I want to display only if the count field is greater than or equal to 2. I have tried this query but it didnt work.

$sql = "SELECT count(*), companyId FROM company WHERE count(*)>='2' GROUP BY companyId";

Does this not work or do i need to make this a having clause?

psycorpse

OK never mind I was able to get it with this query

$sql ="SELECT count(*), companyId FROM tickets GROUP BY companyId HAVING count(*)>='2' ";

Krait

Uhh, that query will always return a result assuming that there are more than two records in the table.

Could you clarify exactly on what you're trying to do?

psycorpse

Well this appears as if it is working. This is what I am tring to get. I have a table of trouble calls. I also have a table of companies. I am trying to see if there are multiple trouble calls for any companies. Since count(*) pulls all trouble calls it might show 1 and I only need the companies that have more than 1.