if (STORAGE == 'sqlite') {
$sql = '
- CREATE TABLE tags_entries (
+ CREATE TABLE IF NOT EXISTS tags_entries (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL UNIQUE,
entry_id INTEGER,
tag_id INTEGER,
public function retrieveEntriesByTag($tag_id) {
$sql =
- "SELECT * FROM entries
+ "SELECT entries.* FROM entries
LEFT JOIN tags_entries ON tags_entries.entry_id=entries.id
WHERE tags_entries.tag_id = ?";
$query = $this->executeQuery($sql, array($tag_id));
public function retrieveTagsByEntry($entry_id) {
$sql =
- "SELECT * FROM tags
+ "SELECT tags.* FROM tags
LEFT JOIN tags_entries ON tags_entries.tag_id=tags.id
WHERE tags_entries.entry_id = ?";
$query = $this->executeQuery($sql, array($entry_id));