I have a postgresql view on which I'm running the following query :
select count(*) AS "Assigned Calls" ,to_timestamp(createdon)::date from vw_issues where to_timestamp(createdon)::date>='11/10/2009' and to_timestamp(createdon)::date<'11/11/2009'
group by to_timestamp(createdon)::date
order by to_timestamp(createdon)::date
when run in phppgadmin the result is displayed as
Assigned Calls to_timestamp
20 2009-10-12
13 2009-10-13
etc...
I need to create a page in php that displays the same results, can you help please?