Problem: MDB_QueryTool problem with addLeftJoin()
| From: | Michael Mussulis | Date: | Sat, 25 Oct 2008 09:28:15 +0000 |
| Subject: | Problem: MDB_QueryTool problem with addLeftJoin() | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-29360@lists.php.net to get a copy of this message | ||
Hi,
When I do $object->getNext() the result does not contain any fields from the
left join.
getNext() returns:
[id_maker] => 1
[make] => AC
The following fields are missing:
[_models_id_model]
[_models_id_maker]
[_models_model]
How come? Am I doing something wrong?
I am using two tables: makers and models. My code is shown below:
$maker = new Maker($dsn);
$maker->useResult('object');
$maker->addLeftJoin("models", "makers.id_maker = models.id_maker");
$recs = $maker->getAll();
I get the following result:
[last_query] => SELECT models.
id_model AS
_models_id_model,models.id_maker AS
_models_id_maker,models.model AS
_models_model,makers.id_maker AS
id_maker,makers.make AS make FROM
makers LEFT JOIN models ON makers.id_maker = models.id_maker
[_data] => Array
(
[0] => Array
(
[_models_id_model] => 1
[_models_id_maker] => 1
[_models_model] => COBRA
[id_maker] => 1
[make] => AC
)
[1] => Array
(
[_models_id_model] => 2
[_models_id_maker] => 2
[_models_model] => ZEST
[id_maker] => 2
[make] => ACREA
)
Thanks,
Michael.