Hi...
Adwin,
(btw: php-db@xxxxxxxxxxxxx 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
