"; } PRINT ""; PRINT ""; //if ($style == "full") //{ // $query = "SELECT * FROM groups WHERE ($field LIKE '$newcontains') $andquery ORDER BY $sort"; //if ($field == "freetext") { $query = "SELECT * from groups WHERE (name LIKE '$newcontains') or (type LIKE '$newcontains') or (description LIKE '$newcontains') or (comments LIKE '$newcontains') or (service LIKE '$newcontains') or (a_notes LIKE '$newcontains') or (a_comments LIKE '$newcontains') ORDER BY $sort"; } // $sth = $adb->prepare($query); // if($sth) // { // $res = $sth->execute(); // $numRows = $sth->rows(); // for($i = 0; $i < $numRows; $i++) // { // $result = $sth->fetchrow_hash(); // if($i < $goto) // { // $ID = $result["ID"]; // showComputer($ID, 0); // if (($goto + 4 - $i) < 1) // { // break; // } // } // } // } else // { // PRINT "Could not prepare query: ".$sth->errstr."
\n"; // } // $backgoto = $goto - 5; // $forgoto = $goto + 5; // PRINT "
"; // if ($backgoto > -1) // { // PRINT "
// // // // // //
"; // } // PRINT "
"; // PRINT "
// // // // // //
"; // PRINT "
"; //} elseif ($style == "list") //{ $query = "SELECT * FROM groups WHERE ($field LIKE '$newcontains') $andquery ORDER BY $sort"; if ($field == "freetext") { $query = "SELECT * from groups WHERE (name LIKE '$newcontains') or (type LIKE '$newcontains') or (description LIKE '$newcontains') or (comments LIKE '$newcontains') or (service LIKE '$newcontains') or (a_notes LIKE '$newcontains') or (a_comments LIKE '$newcontains') ORDER BY $sort"; } //echo "$query $sort, $phrasetype"; //exit; systemsListView($query, $sort, $phrasetype); //} commonFooter(); ?>