Поиск по базе данных

<?php
$link = mysql_connect("","","") or die("Не соединилось!!!");
mysql_select_db("bd") or die("Не найдена БД");
$query = "SELECT * FROM users WHERE UPPER(login) LIKE '%".strtoupper($_POST['nmag'])."%'";
$result = mysql_query($query) or die("Запрос ошибочный");
print "<table>\n";
while ($line = mysql_fetch_array($result, MYSQL_NUM)) {
print "\t<tr>\n";
for ($i=1;$i<=4;$i++) { print "\t\t<td>$line[$i]</td>\n"; }
print "\t</tr>\n";
}
print "</table>\n";
mysql_free_result($result);
mysql_close($link);
 
?>

$query = "SELECT имя, фамилия FROM users WHERE UPPER(login) LIKE '%".strtoupper($_POST['nmag'])."%'";

print "\t<tr>\n";
print "\t\t<td>$line['имя']</td>\n";
print "\t\t<td>$line['фамилия']</td>\n";
print "\t</tr>\n";

while ($line = mysql_fetch_array($result, MYSQL_NUM)) {

while ($line = mysql_fetch_assoc($result)) {

print "<table>\n";
 
while ($line = mysql_fetch_assoc($result)) {
 
print "\t<tr>\n";
print "\t\t<td>$line[name_user]</td>\n";
print "\t\t<td>$line[lastname]</td>\n";
print "\t</tr>\n";
 
}
 
print "</table>\n";
print "</table>\n";

$query = "SELECT * FROM users WHERE UPPER(login) LIKE '%".strtoupper($_POST['nmag'])."%'";

$query = "SELECT * FROM users WHERE UPPER(login) LIKE '%".strtoupper($_POST['nmag'])."%' OR  UPPER(name) LIKE '%".strtoupper($_POST['nmag'])."%'";

$str = preg_replace('#\s+#', ' ', trim($_POST['search'])); // удаляем незначащие пробелы
$fio = explode(' ', $str, 2); // на самом деле тут не FIO, а, скорее, FI :)