<?php
        $db = pg_connect("host=localhost port=5432 dbname=finaldb user=postgres password=cabect");
        $query = "SELECT * FROM food_sources";
        $result = pg_query($query);
        if (!$result) {
            echo "Problem with query " . $query . "<br/>";
            echo pg_last_error();
            exit();
        }
        while($myrow = pg_fetch_assoc($result)) {
            printf ("<tr><td>%a</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td>
													<td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>", $myrow['company_ID'], htmlspecialchars($myrow['Company Name']), htmlspecialchars($myrow['Address']), htmlspecialchars($myrow['Phone Number']));
        }

        ?>