diff options
Diffstat (limited to 'index.php')
| -rw-r--r-- | index.php | 6 |
1 files changed, 3 insertions, 3 deletions
@@ -39,11 +39,11 @@ foreach ($bugs_r as $row) { <?php if(session_set()) { - echo "<p><a href='{$config['urls']['base']}/reports/edit.php'>Create</a></p>\n"; + echo "<p><a href='{$config['urls']['base']}/report/edit.php'>Create</a></p>\n"; } # reports query -$reports_q = 'SELECT title, description, author FROM reports WHERE bug IS NULL'; +$reports_q = 'SELECT reports.id AS id, title, description, users.username AS user FROM reports JOIN users ON reports.author=users.id WHERE bug IS NULL ORDER BY id'; $reports_r = $conn->query($reports_q); if($reports_r->rowCount() > 0) { @@ -53,7 +53,7 @@ if($reports_r->rowCount() > 0) { <tr><th>Title</th><th>Description</th><th>Submitted by</th></tr> <?php foreach ($reports_r as $row) { - echo "<tr><td><a href=view.php?id=$row[id]>$row[title]</a></td> <td>" . truncate($row['description']) . "</td> <td>$row[submitter]</td></tr>\n"; + echo "<tr><td><a href=report/view.php?id=$row[id]>$row[title]</a></td> <td>" . truncate($row['description']) . "</td> <td>$row[user]</td></tr>\n"; } ?> </table> |