From 6ff78f33a75fbabae300497c452112f57bbfab6a Mon Sep 17 00:00:00 2001 From: horus Date: Wed, 14 Feb 2018 13:43:51 +0100 Subject: Minor improvements. (website) --- site/app/Http/Controllers/PageFeedController.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'site/app') diff --git a/site/app/Http/Controllers/PageFeedController.php b/site/app/Http/Controllers/PageFeedController.php index ee4f3ec..0dd1b95 100644 --- a/site/app/Http/Controllers/PageFeedController.php +++ b/site/app/Http/Controllers/PageFeedController.php @@ -22,7 +22,7 @@ class PageFeedController extends Controller { if ($query != "") { $query .= " UNION "; } - $query .= "(SELECT spirit_type as name, image_url, spirit_type, spirit_type AS url, spirit_type AS feedname, '' AS linktext FROM ". $view ."_view WHERE original_price > 19.98 ORDER BY created_at DESC LIMIT 1)"; + $query .= "(SELECT spirit_type as name, image_url, spirit_type, spirit_type AS url, CONCAT(spirit_type,'-Feed') AS feedname, CONCAT('Zum ', spirit_type, '-Feed') AS linktext FROM ". $view ."_view WHERE original_price > 19.98 ORDER BY created_at DESC LIMIT 1)"; } # query mit festen parametern -- cgit v1.2.3