Hledání ve více tabulkách

                <?php
        // gets value sent over search form
        if (isset($_GET['query']))
         $query = $_GET['query'];

        // you can set minimum length of the query if you want
        $min_length = 3;

        // if query length is more or equal minimum length then     
        if(strlen($query) >= $min_length){

          // changes characters used in html to their equivalents, for example: < to &gt;
          $query = htmlspecialchars($query); 

          // makes sure nobody uses SQL injection         
          $query = mysql_real_escape_string($query);

          $results = "(SELECT company_name, street FROM company WHERE company_name LIKE '%" . $query . "%' OR street LIKE '%" . $query ."%') 
                      UNION
                      (SELECT firstname, lastname FROM contacts WHERE firstname LIKE '%" . $query . "%' OR lastname LIKE '%" . $query ."%') 
                      UNION
                      (SELECT contract_name, contract_second_name FROM contracts WHERE contract_name LIKE '%" . $query . "%' OR contract_second_name LIKE '%" . $query ."%')";
          $result = mysql_query($results) or die ("Unable to select data because: ".mysql_error());

          // if one or more rows are returned do following
          if ($result && mysql_num_rows($result) > 0) {

            // $results = mysql_fetch_array($raw_results) puts data from database into array, while it's valid it does the loop
            while($row = mysql_fetch_array($result)){
        ?>

<td><?php echo $row['company_name']; ?> <?php echo $row['street']; ?></td>