[PHP-DB] Re: newbie: how to return one iteration *per unique date (DAY!)* in a timestamp column?

2009-08-03 Thread Nisse Engström
On Mon, 3 Aug 2009 11:52:11 +0200, Nisse Engström wrote: > You could use the date as an index: > > ... SELECT DATE(`datetimecolumn`) AS `date` ... > > while ($TrackingRow = mysql_fetch_object (...)) { > $data[$TrackingRow['date']] = $TrackingRow; >

[PHP-DB] Re: newbie: how to return one iteration *per unique date (DAY!)* in a timestamp column?

2009-08-03 Thread Nisse Engström
On Sun, 2 Aug 2009 16:30:35 -0600, Govinda wrote: > I'm translating some code from another server-side language into PHP, > and I need something that 'summarizes' results found from a MySQL > SELECT. I.e. - > > $foundTrackingRows=mysql_query("SELECT... > while ($TrackingRow = mysql_fetch_obj

[PHP-DB] Re: Unicode error with PostgreSQL

2006-10-03 Thread Nisse Engström
On Tue, 26 Sep 2006 12:05:56 -0600, Tony Grimes wrote: > I'm getting the following error when PHP tries to insert a Unicode character > (the problem word is resume with the accents) into a PostgreSQL database: > > pg_exec(): Query failed: ERROR: Invalid UNICODE character sequence found > (0xe973