diff options
author | CiaranG <ciaran@ciarang.com> | 2008-09-09 03:22:24 -0400 |
---|---|---|
committer | CiaranG <ciaran@ciarang.com> | 2008-09-09 03:22:24 -0400 |
commit | 26634ef0a08234980835698e40b23a291305d1f8 (patch) | |
tree | edb8255b42a7d5da8da942e1084976b9f79e2199 /classes | |
parent | eb4df223e6bb63c4a81e744c74b2f7fae335a8a0 (diff) |
Initial support for PostgreSQL
darcs-hash:20080909072224-f6e2c-881bd2e7fb032f336fecae9ca5ce527dd821d3dc.gz
Diffstat (limited to 'classes')
-rw-r--r-- | classes/User.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/classes/User.php b/classes/User.php index 9251a9a84..96a7482ea 100644 --- a/classes/User.php +++ b/classes/User.php @@ -145,13 +145,13 @@ class User extends DB_DataObject function noticesWithFriends($offset=0, $limit=20) { $notice = new Notice(); - + $notice->query('SELECT notice.* ' . 'FROM notice JOIN subscription on notice.profile_id = subscription.subscribed ' . 'WHERE subscription.subscriber = ' . $this->id . ' ' . 'ORDER BY created DESC, notice.id DESC ' . 'LIMIT ' . $offset . ', ' . $limit); - + return $notice; } |