<table>
<?
include('bd.php');
$searchq = $_GET['name'];

$myrow = mysql_query('SELECT * FROM users ');

$nameArr = explode(" ", $searchq);//Разделяем входную строку на 2 по пробелу
$getName = mysql_query('
    SELECT *
    FROM users
    WHERE
        (firstname LIKE "%'.mysql_real_escape_string(addslashes($searchq)).'%"
        AND activation=1)
        OR (
        lastname LIKE "%'.mysql_real_escape_string(addslashes($searchq)).'%"
        AND activation=1)

        OR (
            firstname LIKE "%'.mysql_real_escape_string(addslashes($nameArr[0])).'%"
            AND lastname LIKE "%'.mysql_real_escape_string(addslashes($nameArr[1])).'%"
            AND activation=1)

        OR (
            lastname LIKE "%'.mysql_real_escape_string(addslashes($nameArr[0])).'%"
            AND firstname LIKE "%'.mysql_real_escape_string(addslashes($nameArr[1])).'%"
            AND activation=1)

');

while ($row = mysql_fetch_array($getName)){
    echo "
    <tr align='left'>

                <div class='all_users'>
                    <td>
                    <a href='page.php?id=".$row['id']."'>
                        <img src='".$row['avatar']."' title='".$row['lastname']." ".$row['firstname']."'>
                    </a>
                    </td>

                    <td>
                        ".$row['login']."<br>
                        ".$row['lastname']." ".$row['firstname']."<br>
                        ".$row['school'].", ".$row['school_form']."<br>
                        ".$row['date_of_birth']."<br>
                    </td>
                </div>

        </tr>";
}
echo "</table><br><br><font size='5'><b>Інші користувачі</b></font><br><hr width='100%' color='blue'>";
?>