Re: [PHP] strange in MySQL Query.
... 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 General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] strange in MySQL Query.
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 TYPE might be a reserved word too - you may want to put that in backticks too. I have an query for mysql that looks like: SELECT group as type FROM mytable WHERE id =101010 UNION SELECT individual as type FROM myothertable WHERE id=101010 The strange result if only one result displayed from myothertable, so the type will become indiv instead of individual. that sounds to me like the result is being grouped! But when I tried to switch the query become : SELECT individual as type FROM myothertable WHERE id=101010 UNION SELECT group as type FROM mytable WHERE id =101010 it could displaye the result correctly. I dont know why .. is this mysql bug ? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php