diff options
author | Bernhard Posselt <nukeawhale@gmail.com> | 2013-03-23 15:17:46 +0100 |
---|---|---|
committer | Bernhard Posselt <nukeawhale@gmail.com> | 2013-03-23 15:17:46 +0100 |
commit | 2956c5c6730f01076fa8c998038bfaad88c09035 (patch) | |
tree | 090d03e3d75fcb858fa9136293e4cfc359094f65 /db | |
parent | 682b01f58db3a522f39b0d6723a909660e440a81 (diff) |
finished itemmappers
Diffstat (limited to 'db')
-rw-r--r-- | db/itemmapper.php | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/db/itemmapper.php b/db/itemmapper.php index 54f406fb1..e4ebee433 100644 --- a/db/itemmapper.php +++ b/db/itemmapper.php @@ -132,9 +132,9 @@ class ItemMapper extends Mapper implements IMapper { public function findAllFeed($id, $limit, $offset, $status, $userId){ $params = array($userId, $status, $id); - $sql = 'AND `items`.`feed_id` = ?'; + $sql = 'AND `items`.`feed_id` = ? '; if($offset !== 0){ - $sql .= 'ADND `items`.`id` > ? '; + $sql .= 'AND `items`.`id` > ? '; array_push($params, $offset); } $sql .= 'ORDER BY `items`.`id` DESC '; @@ -145,9 +145,9 @@ class ItemMapper extends Mapper implements IMapper { public function findAllFolder($id, $limit, $offset, $status, $userId){ $params = array($userId, $status, $id); - $sql = 'AND `feeds`.`folder_id` = ?'; + $sql = 'AND `feeds`.`folder_id` = ? '; if($offset !== 0){ - $sql .= 'ADND `items`.`id` > ? '; + $sql .= 'AND `items`.`id` > ? '; array_push($params, $offset); } $sql .= 'ORDER BY `items`.`id` DESC '; @@ -160,7 +160,7 @@ class ItemMapper extends Mapper implements IMapper { $params = array($userId, $status); $sql = ''; if($offset !== 0){ - $sql .= 'ADND `items`.`id` > ? '; + $sql .= 'AND `items`.`id` > ? '; array_push($params, $offset); } $sql .= 'ORDER BY `items`.`id` DESC '; |