RE: [suspicious - maybe spam] [PHP] [suspicious - maybe spam] strange in MySQL Query.
| From: | Jay Blanchard | Date: | Fri, 14 Jan 2005 12:43:58 +0000 |
| Subject: | RE: [suspicious - maybe spam] [PHP] [suspicious - maybe spam] strange in MySQL Query. | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-206378@lists.php.net to get a copy of this message | ||
[snip]
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.
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 ?
[/snip]
This should probably be asked on the MySQL list.