Поиск по товарам интернет магазина без модуля поиска (на Халяве)

<h1>Поиск по сайту</h1>
<form action="" method="GET">
   <input type="text" name="search" value="<?=isset($_POST['search'])?$_POST['search']:''?>" />
   <input type="submit" name="Найти" value="найти"/>
</form>
<?php
if(isset($_GET['search']) ) {
   $DataBase = & singleton('DataBase');
   $search = to_str($_GET['search']);
   $query = "SELECT shop_items_catalog_item_id as id, shop_items_catalog_name as name,
               shop_items_catalog_description as description, shop_items_catalog_text as text,
      MATCH (shop_items_catalog_name   ,shop_items_catalog_description, shop_items_catalog_text )
      AGAINST ('$search') AS score
    FROM shop_items_catalog_table WHERE
    MATCH (shop_items_catalog_name   ,shop_items_catalog_description, shop_items_catalog_text )
    AGAINST
    ('$search')";
    $return = array();
   $result = $DataBase->select($query);
   
   if ($result) {
      $return = array();
      while( $row = mysql_fetch_assoc($result) ){
         $return[] = $row;
      }
   
   }
   
   $query = "SELECT shop_groups_name as name, shop_groups_description  as description, shop_groups_id as gid,
      MATCH (shop_groups_name   ,shop_groups_description)
      AGAINST ('$search') AS score
    FROM shop_groups_table WHERE
    MATCH (shop_groups_name   ,shop_groups_description)
    AGAINST('$search')";
   
   $result = $DataBase->select($query);
   if ($result) {
      while( $row = mysql_fetch_assoc($result) ){
         $return[] = $row;
      }
   }
   
   function compare($v1, $v2) {
       
       if ( $v1['score'] == $v2['score'] )  {
         return 0;
      }
      
       return ( $v1['score'] < $v2['score'] )?-1:1;
   }

   if(count($return) >0) {
      usort($return, 'compare');
   }
   else{
      $query = "SELECT shop_groups_name as name, shop_groups_description as description, shop_groups_id as gid
              FROM shop_groups_table WHERE  shop_groups_name LIKE '%$search%'
               ";
      
      $result = $DataBase->select($query);
      if ($result) {
         while( $row = mysql_fetch_assoc($result) ){
            $return[] = $row;
         }
      }
      
      $query = "SELECT shop_items_catalog_item_id as id, shop_items_catalog_name as name,
              shop_items_catalog_description  as description, shop_items_catalog_text  as text
              FROM shop_items_catalog_table WHERE shop_items_catalog_name LIKE '%$search%'";
      
      $result = $DataBase->select($query);
      if ($result) {
         while( $row = mysql_fetch_assoc($result) ){
            $return[] = $row;
         }
      }
   }