X-Git-Url: https://git.wh0rd.org/?p=tt-rss.git;a=blobdiff_plain;f=classes%2Flabels.php;h=fd9e454bb106f478b079274e4a306781055b9a5f;hp=4061de57e6c46fff2d378d91dba4d961c7819c60;hb=3a0292303e453f38204279b5d1c978a4b9c367e9;hpb=3b9f982ec6398312ba52cc807c53ce8b78fbc649 diff --git a/classes/labels.php b/classes/labels.php index 4061de57..fd9e454b 100644 --- a/classes/labels.php +++ b/classes/labels.php @@ -42,7 +42,7 @@ class Labels $pdo = Db::pdo(); - $sth = $pdo->prepare("SELECT id, fg_color, bg_color, caption FROM ttrss_labels2 + $sth = $pdo->prepare("SELECT id, fg_color, bg_color, caption FROM ttrss_labels2 WHERE owner_uid = ? ORDER BY caption"); $sth->execute([$owner_uid]); @@ -190,7 +190,7 @@ class Labels $sth->execute([$caption, $owner_uid]); if (!$sth->fetch()) { - $sth = $pdo->prepare("INSERT INTO ttrss_labels2 + $sth = $pdo->prepare("INSERT INTO ttrss_labels2 (caption,owner_uid,fg_color,bg_color) VALUES (?, ?, ?, ?)"); $sth->execute([$caption, $owner_uid, $fg_color, $bg_color]);