[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; /* Store the last row from each set

[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 (0xe97375)