From 968f6448af597b8375b858634f66ade558860aca Mon Sep 17 00:00:00 2001 From: horus Date: Sat, 10 Feb 2018 04:43:48 +0100 Subject: Adds sorting. --- site/app/Http/Controllers/IndexController.php | 15 --------------- 1 file changed, 15 deletions(-) (limited to 'site/app/Http/Controllers/IndexController.php') diff --git a/site/app/Http/Controllers/IndexController.php b/site/app/Http/Controllers/IndexController.php index c0056d9..d175388 100644 --- a/site/app/Http/Controllers/IndexController.php +++ b/site/app/Http/Controllers/IndexController.php @@ -25,21 +25,6 @@ class IndexController extends Controller { $query .= "(SELECT name, image_url, spirit_type, spirit_type AS url, spirit_type AS angebotsname, original_price, discounted_price, procent, '' AS linktext FROM ". $view ."_view WHERE original_price > 19.98 ORDER BY procent DESC LIMIT 1)"; } - // removes the last union - #$query .= substr($query, -1, strlen(" UNION ")); - #echo "
";
-	    #var_dump($query); exit;
-
-	    /*
-	    $dbh = DB::connection('mysql')->getPdo();
-	    $stmt = $dbh->prepare($query);
-	    $stmt->execute();
-
-	    $data = $stmt->fetchAll(\PDO::FETCH_ASSOC);
-	     */
-
-
-	    #var_dump($query); exit;
 	    $data = DB::select($query);
 		#$data = DB::table('whisky_view')->orderBy('procent', 'DESC')->limit(100)->simplePaginate(20);
 
-- 
cgit v1.2.3