diff options
| author | Dries Buytaert <dries@buytaert.net> | 2003-01-20 20:19:21 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2003-01-20 20:19:21 +0000 |
| commit | ca68e8a3c7e0ca054df5e8e3fc7b8be45a287b49 (patch) | |
| tree | d494deb73afc77a1aef716624d7d2e3d1e6b9b82 /modules/blog.module | |
| parent | 73d46a64c3ce9b893bceaa79c1ed5a77e64485f3 (diff) | |
| download | brdo-ca68e8a3c7e0ca054df5e8e3fc7b8be45a287b49.tar.gz brdo-ca68e8a3c7e0ca054df5e8e3fc7b8be45a287b49.tar.bz2 | |
- Tidied up some SQL queries.
Diffstat (limited to 'modules/blog.module')
| -rw-r--r-- | modules/blog.module | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/modules/blog.module b/modules/blog.module index ba241b8af..099ece8e3 100644 --- a/modules/blog.module +++ b/modules/blog.module @@ -130,7 +130,7 @@ function blog_feed_user($uid = 0) { $account = $user; } - $result = db_query("SELECT n.nid, n.title, n.teaser, n.created, u.name, u.uid FROM node n LEFT JOIN users u ON n.uid = u.uid WHERE n.type = 'blog' AND u.uid = '$uid' AND n.status = 1 ORDER BY n.nid DESC LIMIT 15"); + $result = db_query("SELECT n.nid, n.title, n.teaser, n.created, u.name, u.uid FROM node n LEFT JOIN users u ON n.uid = u.uid WHERE n.type = 'blog' AND u.uid = '%d' AND n.status = 1 ORDER BY n.nid DESC LIMIT 15", $uid); $channel["title"] = $account->name. "'s blog"; $channel["link"] = path_uri() . url("blog/view/$uid"); $channel["description"] = $term->description; @@ -296,4 +296,4 @@ function blog_block($op = "list", $delta = 0) { } } -?>
\ No newline at end of file +?> |