Support the ongoing development of Laravel.io →
Database Eloquent Forms

i have this join statement : Item::join('buttons', 'items.cta_id','=','buttons.id')->where('build_id',$id)->get();

the data it returns is correct. however, i also need the id from the my items table. when i echo out id i main getting the value of my buttons table. how do i retrieve the value of the item id?

Last updated 3 years ago.
0

Use the select method to grab exactly what you need in the 2 tables.

Item::join('buttons', 'items.cta_id','=','buttons.id')->where('build_id',$id)->select( array('items.*', 'buttons.*', 'items.id AS id') )->get();
Last updated 3 years ago.
0

thank you.

Last updated 3 years ago.
0

Sign in to participate in this thread!

Eventy

Your banner here too?

embj69 embj69 Joined 26 Feb 2014

Moderators

We'd like to thank these amazing companies for supporting us

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

© 2025 Laravel.io - All rights reserved.