jQuery Ajax geeft string niet door (mysql query) (Opgelost)

$(document).ready(function(){
    var query = '<?=$command?>';

    $.ajax({
        url : "/ajax/searchResults.php",
        type : "POST",
        datatype : "html",
        data : {
            query : query
        },
        success : function(html){
            $('#new_results_list').html(html);
        }
    });
});

$(document).ready(function(){
    var query = '<?=$command?>';
 
    $.ajax({
        url : "/ajax/searchResults.php",
        type : "POST",
        datatype : "html",
        data : {
            query : query
        },
        success : function(html){
            $('#new_results_list').html(html);
        }
    });
});

$(document).ready(function(){
    var query = "SELECT p.ProductNumber, p.assign_breda, p.lock_breda, ((p.nQtyAvailable + p.AvailableFromSupplier + nQtyAvailable_breda + p.nQtyAvailable_shop)> 0) as inVoorraad, pd.product_id,
          p.id, p.ProductType,p.ProductNumber, p.newcollection , p.ItemName, p.ItemNameSub, p.BrandID,
          p.nQtyAvailable,p.AvailableFromSupplier,p.nQtyAvailable_shop,p.nQtyAvailable_breda, p.Diameter,
          p.SpecialOfferMIT,p.SpecialOfferPrice, p.InternetPrice,p.HighVAT, p.show_mm ,p.Diameter, p.for_men, p.for_women, p.for_girls, p.for_boys, p.BandSize, (IF(p.SpecialOfferMIT = '1', p.SpecialOfferPrice, p.InternetPrice) + (IF(p.SpecialOfferMIT = '1', p.SpecialOfferPrice, p.InternetPrice) * IF(p.HighVAT = '1', 0.210, 0.060))) AS price_final
          FROM Products AS p
          INNER JOIN products_domains AS pd
          ON
          p.id = pd.product_id
          LEFT JOIN NewCollection nc
          on nc.id = p.newcollection
          LEFT JOIN brandpage_product_sort bps
          on bps.pid = p.id
          WHERE
          pd.domain_id = "51"
          AND (ProductNumber LIKE "%a%"
        OR ItemName LIKE "%a%"
        OR ItemNameSub LIKE "%a%"
        OR MetaTitle LIKE "%a%"
        OR MetaDescription LIKE "%a%"
        OR MetaKeywords LIKE "%a%"
        OR EAN LIKE "%a%")
        ORDER BY InternetPrice DESC 
          LIMIT 0, 50";
    $.ajax({
        url : "/ajax/searchResults.php",
        type : "POST",
        data : {
            query : query
        },
        success : function(html){
            $('#new_results_list').html(html);
        }
    });
});

$(document).ready(FUNCTION(){
    var query = "SELECT p.ProductNumber, p.assign_breda, p.lock_breda, ((p.nQtyAvailable + p.AvailableFromSupplier + nQtyAvailable_breda + p.nQtyAvailable_shop)> 0) as inVoorraad, pd.product_id,
          p.id, p.ProductType,p.ProductNumber, p.newcollection , p.ItemName, p.ItemNameSub, p.BrandID,
          p.nQtyAvailable,p.AvailableFromSupplier,p.nQtyAvailable_shop,p.nQtyAvailable_breda, p.Diameter,
          p.SpecialOfferMIT,p.SpecialOfferPrice, p.InternetPrice,p.HighVAT, p.show_mm ,p.Diameter, p.for_men, p.for_women, p.for_girls, p.for_boys, p.BandSize, (IF(p.SpecialOfferMIT = '1', p.SpecialOfferPrice, p.InternetPrice) + (IF(p.SpecialOfferMIT = '1', p.SpecialOfferPrice, p.InternetPrice) * IF(p.HighVAT = '1', 0.210, 0.060))) AS price_final
          FROM Products AS p
          INNER JOIN products_domains AS pd
          ON
          p.id = pd.product_id
          LEFT JOIN NewCollection nc
          on nc.id = p.newcollection
          LEFT JOIN brandpage_product_sort bps
          on bps.pid = p.id
          WHERE
          pd.domain_id = "51"
          AND (ProductNumber LIKE "%a%"
        OR ItemName LIKE "%a%"
        OR ItemNameSub LIKE "%a%"
        OR MetaTitle LIKE "%a%"
        OR MetaDescription LIKE "%a%"
        OR MetaKeywords LIKE "%a%"
        OR EAN LIKE "%a%")
        ORDER BY InternetPrice DESC 
          LIMIT 0, 50";
    $.ajax({
        url : "/ajax/searchResults.php",
        type : "POST",
        DATA : {
            query : query
        },
        success : FUNCTION(html){
            $('#new_results_list').html(html);
        }
    });
});

DROP TABLE Products 

DROP TABLE Products