Support the ongoing development of Laravel.io →
Varun Nath A V varunnathav
posted 7 years ago
Eloquent Database
Last updated 2 years ago.
0
ramin raminhti
replied 7 years ago

hi, you can use db::raw('select Distinct count * from tables')

0
Varun Nath A V varunnathav
replied 7 years ago

Thanks for the reply Ramin.

I have tried your suggestion, but didnt work as expected. I need to fetch details from both the tables. So I am using a left join for this.That is why I have used distinct() function to prevent duplicate records. I am getting all the records as expected, but while using the Laravel "paginate()" function, the total count returned is wrong - the count returns the number of all records(Including duplicates).

Last updated 7 years ago.
0

Sign in to participate in this thread!

Eventy

Your banner here too?

Varun Nath A V Varun Nath A V varunnathav Joined 1 Aug 2017

Moderators

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

Eventy
Fathom
Forge
Envoyer
Beyond Code
BairesDev
N-iX

Your logo here?

Laravel.io

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

Laravel.io

Forum Articles Pastebin

Socials

X (Twitter) Bluesky Bluesky GitHub

The community

Laravel Laravel Laravel News Laravel News
Laracasts Laracasts Laravel Podcast Laravel Podcast
© 2024 Laravel.io - All rights reserved.
Terms of service Privacy policy Advertise