[Resolved] Select query not returning anything

[ph3n0m]

I am using the following query

select fileid, COUNT(*) as counts from owners_files group by fileid having counts>=1 order by counts desc

However nothing is being returned - even though I have physically checked the database and

a) the table owners_files exists
b) the field fileid exists
c) the table is populated with information
d) fileid in some cases occurs more then 1 per entry

In theory my select should return something but its returning nothing

Has anyone encountered this problem before, or can spot a mistake in what I am doing.

[ph3n0m]

FYI

the full query was

$result3 = pg_query($dbconn3, "select fileid, COUNT(*) as counts from owners_files group by fileid having a>=2") or die ("Eh something went screwy");

yes it looks like postgreSQL does not like alias so I have changed the query to this:

$result3 = pg_query($dbconn3, "select fileid, COUNT() as counts from owners_files group by fileid having COUNT()>=2") or die ("Eh something went screwy");

and it works fine