boyjarv
1 month ago

Group By created_by date - error in SQL syntax

Posted 1 month ago by boyjarv

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax

here is my SQL:

Tagin::latest(DB::raw("DATE_FORMAT(created_at, %Y-%m-%d) as date"))->where('venue_id',$id)

I just want to display one date and then multiple tagins for each date

Please sign in or create an account to participate in this conversation.