Support the ongoing development of Laravel.io →
kkozlovskis
posted 7 years ago
Database
Last updated 2 years ago.
0
kkozlovskis
replied 7 years ago
Solution

The fault was with quotation marks. Correct query:

DB::select(DB::raw(" SELECT * , (SELECT min(date) FROM Subproducts WHERE Products.id = Subproducts.productid AND date >= ' $minUpcomingDate. %' ) as minDate FROM Products WHERE status = 1 AND upcoming = 1 ORDER BY minDate "));

0

Sign in to participate in this thread!

Eventy

Your banner here too?

kkozlovskis kkozlovskis Joined 20 Jul 2016

Moderators

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

Eventy
Fathom
Forge
Envoyer
Beyond Code
Skynet Technologies
Steadfast Collective
BairesDev
Remotely Works

Your logo here?

Laravel.io

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

Laravel.io

Forum Articles Pastebin

Socials

X Twitter 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