summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorCiaranG <ciaran@ciarang.com>2009-03-05 16:18:31 +0000
committerCiaranG <ciaran@ciarang.com>2009-03-05 16:18:31 +0000
commite5345d8d7a5b519cfb24c9e2a971b485b3c1c872 (patch)
treeb449aef2786efd1746b4f631fd82eaf3cb51c316
parent97bc187e3132663ceadd2a779ce43ca67a7f3a02 (diff)
PostgreSQL - fixed a couple more quoting issues
-rw-r--r--classes/Notice_tag.php2
-rw-r--r--classes/User.php4
2 files changed, 3 insertions, 3 deletions
diff --git a/classes/Notice_tag.php b/classes/Notice_tag.php
index 0365973f5..f2247299a 100644
--- a/classes/Notice_tag.php
+++ b/classes/Notice_tag.php
@@ -40,7 +40,7 @@ class Notice_tag extends Memcached_DataObject
$qry =
'SELECT notice.* ' .
'FROM notice JOIN notice_tag ON notice.id = notice_tag.notice_id ' .
- 'WHERE notice_tag.tag = "%s" ';
+ "WHERE notice_tag.tag = '%s' ";
return Notice::getStream(sprintf($qry, $tag),
'notice_tag:notice_stream:' . common_keyize($tag),
diff --git a/classes/User.php b/classes/User.php
index 40cf18df6..8b0b9acd5 100644
--- a/classes/User.php
+++ b/classes/User.php
@@ -589,7 +589,7 @@ class User extends Memcached_DataObject
'JOIN profile_tag ON (profile_tag.tagged = subscription.subscriber ' .
'AND profile_tag.tagger = subscription.subscribed) ' .
'WHERE subscription.subscribed = %d ' .
- 'AND profile_tag.tag = "%s" ' .
+ "AND profile_tag.tag = '%s' " .
'AND subscription.subscribed != subscription.subscriber ' .
'ORDER BY subscription.created DESC ';
@@ -617,7 +617,7 @@ class User extends Memcached_DataObject
'JOIN profile_tag on (profile_tag.tagged = subscription.subscribed ' .
'AND profile_tag.tagger = subscription.subscriber) ' .
'WHERE subscription.subscriber = %d ' .
- 'AND profile_tag.tag = "%s" ' .
+ "AND profile_tag.tag = '%s' " .
'AND subscription.subscribed != subscription.subscriber ' .
'ORDER BY subscription.created DESC ';