<?php
$servername = "localhost";
$username = "root";
$password = "";
$myDB = "publicationsFiles";
$id = 100;
$order="ASC";

/*$orders=array("name","price","qty");
$key=array_search($_GET['sort'],$orders));
$order=$orders[$key];*/
$query="select * from $myDB WHERE id < $id ORDER BY id  $order";

try {
    $db = new PDO("mysql:host=$servername;dbname=$myDB", $username, $password);
    // set the PDO error mode to exception
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        if ($db->getAttribute(PDO::ATTR_DRIVER_NAME) == 'mysql') {
            $stmt = $db->prepare($query);

            $exec = $stmt->execute();
            $pojedyncze = $stmt->fetchAll(PDO::FETCH_NUM);

        } else {
            die("my application only works with mysql; I should use \$stmt->fetchAll() instead");
        }
    }
catch(PDOException $e)
    {
    echo "Connection failed: " . $e->getMessage();
    }
?>