<?php
    echo "<form action=\"modules.php\" mehtod=\"POST\" style=\"margin-top: 0; margin-bottom: 0\">"
        ."<input type=\"hidden\" name=\"name\" value=\"schule\">"
        ."<input type=\"hidden\" name=\"file\" value=\"schule_suche\">"
        ."<input type=\"text\" name=\"gesucht\" size=\"25\" maxlength=\"50\"> "
        ."<input type=\"submit\" value=\""._NASEARCH."\">"
        ."</form>";
?>

  $result = $db->sql_query("select cid,catid,title,schule,plz,place,bland,start,end,mobil,hp,mail,fax,bildneu,description,tel2 from schule where ( title LIKE '%$gesucht%' or schule LIKE '%$gesucht%' or plz LIKE '$gesucht%' or place LIKE '%$gesucht%' or description LIKE '%$gesucht%') limit $startpos,$rows_per_side");
  $result1 = $db->sql_query("select cid,catid,title,schule,plz,place,bland,start,end,mobil,hp,mail,fax,bildneu,description,tel2 from schule where ( title LIKE '%$gesucht%' or schule LIKE '%$gesucht%' or plz LIKE '$gesucht%' or place LIKE '%$gesucht%' or description LIKE '%$gesucht%') ");
  $count = $db->sql_numrows($result1);