Lines Matching refs:sql

378         $sql = "SELECT * FROM addresslist WHERE id = $cid";
379         $query = $sqlite->query($sql);
381         if (ADRESSBOOK_SQL) msg("<code>$sql</code>",2);
473                 $sql = "INSERT INTO addresslist
478                     if ($k != 'photo') $sql .= "'".$info[$k]."',";
479                     if ($k == 'photo') $sql .= "'$blob'";
482                 $sql .= ')';
486                 $res = $sqlite->query($sql);
488                 if (ADRESSBOOK_SQL) msg("<code>$sql</code>",2);
496                 $sql = "UPDATE addresslist SET ";
499                     if ($k != 'photo') $sql .= " $k = '".$info[$k]."', ";
500                     if ($k == 'photo')  $sql .= " $k = '$blob'";
503                 $sql .= " WHERE id = ".$_REQUEST['contactid'];
505                 if (ADRESSBOOK_SQL) msg("<code>$sql</code>",2);
507                 $res = $sqlite->query($sql);
524         $sql = "DELETE FROM addresslist WHERE id = $cid";
525         $sqlite->query($sql);
527         if (ADRESSBOOK_SQL) msg("<code>$sql</code>",2);
591 …$sql = "select * from addresslist WHERE instr(lower(surname || firstname || tel1 || tel2 || fax ||…
592 …for ($c=1;$c<count($text);$c++) $sql .= " AND instr(lower(' ' || surname || firstname || tel1 || t…
593         $sql .= " ORDER BY $order";
595         $query = $sqlite->query($sql);
598         if (ADRESSBOOK_SQL) msg("<code>$sql</code>",2);
600         if ($sqlite->res2count($sqlite->query($sql)) == 0) {
620             $sql = "select * from addresslist ORDER BY $order";
625 …$sql = "select * from addresslist WHERE UPPER(department) = UPPER('".$filters['department']."') OR…
628         $query = $sqlite->query($sql);
631         if (ADRESSBOOK_SQL) msg("<code>$sql</code>",2);
634         if ($sqlite->res2count($sqlite->query($sql)) == 0) {
671 …      $sql = "SELECT DISTINCT $column FROM addresslist WHERE $column NOT LIKE '' ORDER by $column";
673         $query = $sqlite->query($sql);
676         if (ADRESSBOOK_SQL) msg("<code>$sql</code>",2);
679         if ($sqlite->res2count($sqlite->query($sql)) == 0) {
939         $sql = "select * from addresslist  WHERE id = 1";
941         $query = $sqlite->query($sql);
946             $sql = "INSERT INTO addresslist
949             foreach ($res as $k=>$r) $sql.= "'$r'".($k=='photo'? ')':',');
950             $query = $sqlite->query($sql);