aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorHabeas Codice <habeascodice@federated.social>2015-03-12 00:28:49 -0700
committerHabeas Codice <habeascodice@federated.social>2015-03-12 00:28:49 -0700
commit1578c49976110c6c4c0a0dcf63ba40be4529045c (patch)
treec9ab80c98a3bad4fb1aed501c3374ec88b49bc19
parent76fedfe1f89e671c625598d48508195bab98e969 (diff)
downloadvolse-hubzilla-1578c49976110c6c4c0a0dcf63ba40be4529045c.tar.gz
volse-hubzilla-1578c49976110c6c4c0a0dcf63ba40be4529045c.tar.bz2
volse-hubzilla-1578c49976110c6c4c0a0dcf63ba40be4529045c.zip
substr() is a mysql alias for substring(). substring() is in the SQL standard and is supported by both
databases.
-rw-r--r--mod/dirsearch.php2
1 files changed, 1 insertions, 1 deletions
diff --git a/mod/dirsearch.php b/mod/dirsearch.php
index b4154c1eb..07621aaef 100644
--- a/mod/dirsearch.php
+++ b/mod/dirsearch.php
@@ -195,7 +195,7 @@ function dirsearch_content(&$a) {
// This will make a handful of channels whose names begin with
// punctuation un-searchable in this mode
- $safesql .= " and ascii(substr(xchan_name FROM 1 FOR 1)) > 64 ";
+ $safesql .= " and ascii(substring(xchan_name FROM 1 FOR 1)) > 64 ";
}
elseif($sort_order == 'reverse')
$order = " order by xchan_name desc ";