equal
deleted
inserted
replaced
241 domains.id AS domain_id, |
241 domains.id AS domain_id, |
242 zones.owner, |
242 zones.owner, |
243 domains.name AS domainname |
243 domains.name AS domainname |
244 FROM domains |
244 FROM domains |
245 LEFT JOIN zones ON domains.id=zones.domain_id |
245 LEFT JOIN zones ON domains.id=zones.domain_id |
246 WHERE substring(domains.name,1,1) ".$sql_regexp." ".$db->quote("^".$letter); |
246 WHERE substring(domains.name,1,1) ".$sql_regexp." ".$db->quote("^".$letter, 'text'); |
247 $db->setLimit(1); |
247 $db->setLimit(1); |
248 $result = $db->query($query); |
248 $result = $db->query($query); |
249 $numrows = $result->numRows(); |
249 $numrows = $result->numRows(); |
250 if ( $numrows == "1" ) { |
250 if ( $numrows == "1" ) { |
251 return 1; |
251 return 1; |