@@ -36,7 +36,7 @@ discard block |
||
36 | 36 | |
37 | 37 | //1ere methode: Utilisation de MYSQL |
38 | 38 | // marche mais n'est peu souple |
39 | - /* |
|
39 | + /* |
|
40 | 40 | * $results = DB::select(' |
41 | 41 | SELECT ROUND(AVG(TIMESTAMPDIFF(YEAR,dob, NOW()))) as age |
42 | 42 | FROM actors |
@@ -59,7 +59,7 @@ discard block |
||
59 | 59 | |
60 | 60 | // MAITRISE |
61 | 61 | |
62 | - $results = DB::table('actors') |
|
62 | + $results = DB::table('actors') |
|
63 | 63 | ->select(DB::raw('ROUND(AVG(TIMESTAMPDIFF(YEAR,dob, NOW()))) as age')) |
64 | 64 | ->first(); |
65 | 65 |