Zend Framework - Select query question

Question

I have a query where i join a couple of tables. 2 tables contain the same fieldname, so i want to select 1 table AS another name. I know how to do that, but it seems that when i query a field AS another name, it selects only that field.

My question is: how can i select all fields in the table, and a particular field AS another name?

This is how i have my code at this moment:

    $select->from('one');
    $select->join('two', 'one.item_id = two.id', array('item_name' => 'name'));
    $select->join('three', 'one.item_id = three.item_id');

So i want to select all from two, and name the field name AS item_name.

Thanks in advance!

You should do it how it's supposed to be done: selecting EACH field you need. You're familiar with the subject "do not select *", I assume. — Bogdan Constantinescu
– Bogdan Constantinescu, Commented Mar 25, 2011 at 12:05
Well, have a LOT of fields and i have to select them all, so I was hoping for an easier way :( Can you explain why select * is bad practice? Thanks. — priktop
– priktop, Commented Mar 25, 2011 at 12:08

priktop · Accepted Answer · 2011-03-25 13:47:36Z

1

I haven't tried this but I think you're able to do this:

$select->join('two', 'one.item_id = two.id', array('item_name' => 'name', '*'));

edited Mar 25, 2011 at 13:47

priktop

1,1553 gold badges12 silver badges30 bronze badges

answered Mar 25, 2011 at 12:50

Htbaa

2,30918 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Htbaa Over a year ago

I see you edited my answer, that's fine, but both notations ('name as item_name' or 'item_name' => 'name') will work, in case someone is interested :-).

Collectives™ on Stack Overflow

Zend Framework - Select query question

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related