From 1578c49976110c6c4c0a0dcf63ba40be4529045c Mon Sep 17 00:00:00 2001 From: Habeas Codice Date: Thu, 12 Mar 2015 00:28:49 -0700 Subject: substr() is a mysql alias for substring(). substring() is in the SQL standard and is supported by both databases. --- mod/dirsearch.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'mod/dirsearch.php') 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 "; -- cgit v1.2.3