Re: [PHP] strange in MySQL Query.

2005-01-15 Thread Mattias Thorslund
... I dont know why .. is this mysql bug ? It's a known bug in MySQL. Since this is a PHP list, I leave it up to you to check what version fixed it. IIRC, it's possible to work around by making sure the first statement has the longest data type. -- More views at http://www.thorslund.us -- PHP

Re: [PHP] strange in MySQL Query.

2005-01-14 Thread Jochem Maas
adwin wijaya wrote: Hi... Adwin, (btw: php-db@lists.php.net would be a better place for this question) do you realise that GROUP is an SQL keyword (as in the GROUP BY clause) and as such you will need to escape it using backticks (in the case of MySQL). Also I have a sneaking suspicion that