Lines Matching refs:sql
196 $sql = "select * from endpoints ";
198 $sql .= "where class='$base' ";
199 if (!$all) $sql .= "and status=1";
201 if (!$all) $sql .= "where status=1";
202 $sql .= " order by endpointName";
205 $db_ep = $this->dbc->getAll($sql,NULL, DB_FETCHMODE_ASSOC );
207 echo $sql."\n";
234 $sql = "select * from results where class='$test' and type='$type' and wsdl=$wsdl";
235 $results = $this->dbc->getAll($sql,NULL, DB_FETCHMODE_ASSOC );
274 $sql = "delete from results where endpoint=$endpoint_id ".
279 $res = $this->dbc->query($sql);
285 $sql = "insert into results (endpoint,stamp,class,type,wsdl,function,result,error,wire) ".
293 $res = $this->dbc->query($sql);
666 $sql = "select distinct(function) from results where class='$test' order by function";
667 $results = $this->dbc->getAll($sql);