diff options
| author | Nicolas Lœuillet <nicolas.loeuillet@gmail.com> | 2014-01-03 10:06:26 +0100 |
|---|---|---|
| committer | Nicolas Lœuillet <nicolas.loeuillet@gmail.com> | 2014-01-03 10:06:26 +0100 |
| commit | 9de34d4e8430b8b2d994aa9b681ec9f11dabf0b7 (patch) | |
| tree | a64cc45bdf23a873e2c8ae20751c7ec2783722e3 | |
| parent | da5fc42f615eeb45a702604970f94967507fb432 (diff) | |
| download | wallabag-9de34d4e8430b8b2d994aa9b681ec9f11dabf0b7.tar.gz wallabag-9de34d4e8430b8b2d994aa9b681ec9f11dabf0b7.tar.zst wallabag-9de34d4e8430b8b2d994aa9b681ec9f11dabf0b7.zip | |
[fix] error in query to get entries and tags
| -rw-r--r-- | inc/poche/Database.class.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/inc/poche/Database.class.php b/inc/poche/Database.class.php index afe02a41..d8b63859 100644 --- a/inc/poche/Database.class.php +++ b/inc/poche/Database.class.php | |||
| @@ -337,7 +337,7 @@ class Database { | |||
| 337 | 337 | ||
| 338 | public function retrieveEntriesByTag($tag_id) { | 338 | public function retrieveEntriesByTag($tag_id) { |
| 339 | $sql = | 339 | $sql = |
| 340 | "SELECT * FROM entries | 340 | "SELECT entries.* FROM entries |
| 341 | LEFT JOIN tags_entries ON tags_entries.entry_id=entries.id | 341 | LEFT JOIN tags_entries ON tags_entries.entry_id=entries.id |
| 342 | WHERE tags_entries.tag_id = ?"; | 342 | WHERE tags_entries.tag_id = ?"; |
| 343 | $query = $this->executeQuery($sql, array($tag_id)); | 343 | $query = $this->executeQuery($sql, array($tag_id)); |
| @@ -348,7 +348,7 @@ class Database { | |||
| 348 | 348 | ||
| 349 | public function retrieveTagsByEntry($entry_id) { | 349 | public function retrieveTagsByEntry($entry_id) { |
| 350 | $sql = | 350 | $sql = |
| 351 | "SELECT * FROM tags | 351 | "SELECT tags.* FROM tags |
| 352 | LEFT JOIN tags_entries ON tags_entries.tag_id=tags.id | 352 | LEFT JOIN tags_entries ON tags_entries.tag_id=tags.id |
| 353 | WHERE tags_entries.entry_id = ?"; | 353 | WHERE tags_entries.entry_id = ?"; |
| 354 | $query = $this->executeQuery($sql, array($entry_id)); | 354 | $query = $this->executeQuery($sql, array($entry_id)); |