From 04f53e2d62a402661dcc2ef4aa635c352c0a134d Mon Sep 17 00:00:00 2001
From: arf20 <aruizfernandez05@gmail.com>
Date: Tue, 19 Mar 2024 05:03:32 +0100
Subject: Index, and client comments

---
 client.php | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

(limited to 'client.php')

diff --git a/client.php b/client.php
index 5d33ba2..43dd78b 100644
--- a/client.php
+++ b/client.php
@@ -14,7 +14,7 @@ $type = $_SESSION["type"];
 require_once "config.php";
 
 // Get orders
-$sql = "SELECT id, service, name, billing FROM orders WHERE client = ?";
+$sql = "SELECT id, service, name, billing, comments FROM orders WHERE client = ?";
 $stmt = mysqli_prepare($link, $sql);
 mysqli_stmt_bind_param($stmt, "s", $param_client);
 $param_client = $clientid;
@@ -61,10 +61,10 @@ function getservicebyid($id) {
                         <div class="col5">
                             <h3>Active services</h3>
                             <table>
-                                <tr><th>service</th><th>instance</th><th>billing</th></tr>
+                                <tr><th>service</th><th>instance</th><th>billing</th><th>comments</th></tr>
                                 <?php
                                 foreach ($orders as $order) {
-                                    echo "<tr><td>".getservicebyid($order["service"])["name"]."</td><td>".$order["name"]."</td><td>".$order["billing"]."</tr>\n";
+                                    echo "<tr><td>".getservicebyid($order["service"])["name"]."</td><td>".$order["name"]."</td><td>".$order["billing"]."</td><td><pre>".$order["comments"]."</pre></td></tr>\n";
                                 }
                                 ?>
                             </table>
-- 
cgit v1.2.3