samedi 29 août 2015

ho to select last 30 day data with join table user and employees table in laravel 5.0

recent_employees =DB::table('users.created_at') ->join('employees', 'users.id', '=', 'employees.user_id')

        ->select('users.id', 'name','created_at')
        ->where DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= 'created_at';
        ->get();



from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/1hL8Mzm
via IFTTT

Aucun commentaire:

Enregistrer un commentaire