From 1388a64651f1c61a6aafc32f8e3e60f7a6ffd339 Mon Sep 17 00:00:00 2001 From: George Halkiadakis Date: Tue, 6 Jun 2023 00:46:19 +0300 Subject: admin petition ready --- public/app/models/Content_model.php | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'public/app/models/Content_model.php') diff --git a/public/app/models/Content_model.php b/public/app/models/Content_model.php index 1f145a0..cfe418f 100644 --- a/public/app/models/Content_model.php +++ b/public/app/models/Content_model.php @@ -91,7 +91,10 @@ class Content_model { public static function all_petitions() { return Registry::use('database')->runQuery( - "SELECT * FROM petition", + "SELECT petition.*, + CONCAT(user.last_name, ' ', user.first_name) as UserName + FROM petition + LEFT JOIN user ON user.id = petition.user_id", [] ); } -- cgit v1.2.3