$query1 = mysql_query("SELECT * FROM ".$userstable1." WHERE name LIKE '%".$_GET['q']."%'");
$query2 = mysql_query("SELECT * FROM ".$userstable2." WHERE name LIKE '%".$_GET['q']."%'");
$query3 = mysql_query("SELECT * FROM ".$userstable3." WHERE name LIKE '%".$_GET['q']."%'");
$query4 = mysql_query("SELECT * FROM ".$userstable4." WHERE name LIKE '%".$_GET['q']."%'");
$create_temp = mysql_db_query($dbName, "CREATE TABLE temp
(n INT( 25 ) NOT NULL,
mem VARCHAR( 25 ) NOT NULL,
name VARCHAR( 250 ) NOT NULL,
cost VARCHAR( 25 ) NOT NULL)");
$row_comp = mysql_num_rows($query1);
$insert_temp_num_comp = mysql_db_query($dbName, "INSERT INTO temp VALUES ('none', 'none', '<b><font color=#009933>Раздел ¨Компьютерная 1¨ Всего найдено: [".$row_comp."]</font></b>',' ')");
while($row_1 = mysql_fetch_array($query1))
{
$insert_temp = mysql_db_query($dbName, "INSERT INTO temp VALUES ('".$row_1["n"]."', '".$row_1["mem"]."', '".$row_1["name"]."','".$row_1["cost"]."')");
}
$row_office = mysql_num_rows($query2);
$insert_temp_num_comp = mysql_db_query($dbName, "INSERT INTO temp VALUES ('none', 'none', '<b><font color=#009933>Раздел ¨ Всего найдено: [".$row_office."]</font></b>',' ')");
while($row_2 = mysql_fetch_array($query2))
{
$insert_temp = mysql_db_query($dbName, "INSERT INTO temp VALUES ('".$row_2["n"]."', '".$row_2["mem"]."', '".$row_2["name"]."','".$row_2["cost"]."')");
}
$row_rasch = mysql_num_rows($query3);
$insert_temp_num_comp = mysql_db_query($dbName, "INSERT INTO temp VALUES ('none', 'none', '<b><font color=#009933>Раздел ¨ Всего найдено: [".$row_rasch."]</font></b>',' ')");
while($row_3 = mysql_fetch_array($query3))
{
$insert_temp = mysql_db_query($dbName, "INSERT INTO temp VALUES ('".$row_3["n"]."', '".$row_3["mem"]."', '".$row_3["name"]."','".$row_3["cost"]."')");
}
$row_kanz = mysql_num_rows($query4);
$insert_temp_num_comp = mysql_db_query($dbName, "INSERT INTO temp VALUES ('none', 'none', '<b><font color=#009933>Раздел ڔ¨ Всего найдено: [".$row_kanz."]</font></b>',' ')");
while($row_4 = mysql_fetch_array($query4))
{
$insert_temp = mysql_db_query($dbName, "INSERT INTO temp VALUES ('".$row_4["n"]."', '".$row_4["mem"]."', '".$row_4["name"]."','".$row_4["cost"]."')");
}
$q_temp_all = mysql_query("SELECT * FROM temp");
$lines_per_page = $str;
$all_lines = mysql_num_rows($q_temp_all);
if (!isset($page) or empty($page) or $page<=0) $page=1;
else $page=(int)$page;
$page_for_query = $page-1;
$lpos = $page_for_query * $lines_per_page;
if(!($all_lines=mysql_num_rows($q_temp_all)))
exit("Ничего не найдено! Повторите поиск, изменив условия запроса.");
else
{
echo "<table border=0 width=692 cellspacing=0 cellpadding=0 bgcolor=#cccccc>
<col class=col1><col align=right>
<tr bgcolor=#e1e1e1><td nowrap><b> Наименование</b><br><hr size=1 color=#9999CC></td><td><b> Цена, руб</b><br><hr size=1 color=#9999CC></td></tr>";
$query = "SELECT * FROM temp LIMIT $lpos,$lines_per_page";
$result = @mysql_query($query) or die("$query <b>failed!</b><br>".mysql_error());
$count_ = ceil($all_lines / $lines_per_page);
while ($data_array = mysql_fetch_array($result))
{
$count_++;
echo "<tr";
if ($count_/2==intval($count_/2)) echo " bgcolor=#e1e1e1";
echo " height=20><td>".$data_array['name']."</td><td>".$data_array['cost']."</td></tr>";
}
echo "</table><br>";
echo "<b>Всего найдено:</b> ".$all_lines."<br>";
echo "<b>Вывод на страницу по:</b> ".$str." <b>записей</b><br>";
if ($all_lines <= $lines_per_page){
echo "<b>Страница 1</b><br>";}
else {
echo "<b>Страницы:</b> ";}
$count_pages = ceil($all_lines / $lines_per_page);
if ($count_pages>1) {
for ($i=1; $i<=$count_pages; $i++) {
if($page==$i and $i!=1) {echo " | $i";}
elseif ($page==$i and $i==1) {echo "1";}
elseif($i==1 and $page!=$i) {echo "<a href=\"$_SERVER[PHP_SELF]?q=$q&group=$group&style=$style&str=$str&page=$i\">$i</a>";}
elseif($i!=1 and $page!=$i) {echo " | <a href=\"$_SERVER[PHP_SELF]?q=$q&group=$group&style=$style&str=$str&page=$i\">$i</a>";}
}
}
}
$delete_temp = mysql_db_query($dbName, "DROP TABLE temp");
mysql_close($connect);
}