//error_reporting( E_ALL ); $query = "SELECT mercazAllId,domain,merSchema,mercazDisplayName,logo " . "FROM `mercazim` WHERE marcazActiv = 1 AND pandingSite = 0 AND merSchema > 4 AND `matnasnet` = 1 ORDER BY merSchema"; //pqpq1 include_once '../classes/MysqliConnect1.php'; $pqpq1List1 = $mysqli1->query($query); //pqpq2 include_once '../classes/MysqliConnect2.php'; $pqpq1List2 = $mysqli2->query($query); //pqpq3 include_once '../classes/MysqliConnect3.php'; $pqpq1List3 = $mysqli3->query($query); //pqpq4 //include_once '../classes/MysqliConnect4.php'; //$pqpq1List4 = $mysqli4->query($query); //pqpq5 include_once '../classes/MysqliConnect5.php'; $pqpq1List5 = $mysqli5->query($query); while ($row = mysqli_fetch_array($pqpq1List1)) { $row['pqpq'] = 1; $all[$row['merSchema']][$row['mercazAllId']] = $row; } while ($row2 = mysqli_fetch_array($pqpq1List2)) { $row2['pqpq'] = 2; $all[$row2['merSchema']][$row2['mercazAllId']] = $row2; } while ($row3 = mysqli_fetch_array($pqpq1List3)) { $row3['pqpq'] = 3; $all[$row3['merSchema']][$row3['mercazAllId']] = $row3; } //while ($row4 = mysqli_fetch_array($pqpq1List4)) { // $row4['pqpq'] = 4; // $all[$row4['merSchema']][$row4['mercazAllId']] = $row4; //} while ($row5 = mysqli_fetch_array($pqpq1List5)) { $row5['pqpq'] = 5; $all[$row5['merSchema']][$row5['mercazAllId']] = $row5; } foreach ($all as $schema => $schemaArray) { $print.='
echo $print; ?>