I have this elementary query:
SELECT d.description, o.code FROM order_positions AS o
LEFT JOIN article_descriptions AS d ON (o.article_id = d.article_id)
WHERE o.order_id = 1
and I'm using MDB2
from PEAR
to execute it and read the return values.
But somehow the result array always contains fields from the order_positions
table only!, i.e. the result array looks like this
row[code] = 'abc123'
while I want it to look like this
row[description] = 'my description'
row[code] = 'abc123'
I already tried the following:
code
first, then description
.SELECT FROM table1, table2 WHERE table1.id = table2.id
)AS
.Some other facts:
order_positions
table seems to be preferred, no matter what. When joining with additional tables I still only get fields from this table.OK, I found the cause:
Fields with NULL
values are not added to the array. In my test scenario description
was in fact null and hence was not available in the array.
I'll still keep this (embarrassing) question, just in case someone else has this problem in the future.
Facepalm http://www.scienceblogs.de/frischer-wind/picard-facepalm-thumb-512x409.jpg