<?php
                $conn = pg_connect("host=database.dcs.aber.ac.uk
                port=5432 dbname=teaching user=csguest password=rohishe");
                getTotal();
                for ($i = 0; $i<$total; $i++)
                {

                    $basketArray[$i];
                    $res = pg_query ($conn, "select * from CSGames where refnumber = " . $now . "");
                    echo "<table border='1'>";
                    while ($b = pg_fetch_array ($res))
                    {
                        echo "<tr>";
                        echo "<td>" . $b["title"] . "</td>";
                        echo "<td>" . $b["price"] . "</td>";
                        echo "<td>" . $b["description"] . "</td>";
                                    $ref = $b['refnumber'];
                        echo "<td>" . "<a href=listings.php?action=delete&refnumber=" . $ref . ">Remove</a>" . "</td>";
                        echo "</tr>";
                    }
                    echo "</table>\n";
                }
            ?>