PHP getAgenciasLogosJSONの例

コード例 #1

ファイル: index.php プロジェクト: hevelmo/compress

function getAgenciesNewsPrincipales()
{
    $sql = "SELECT *\r\n                FROM (\r\n                    SELECT *\r\n                    FROM camAgencias\r\n                    WHERE AGN_Tipo = 1\r\n                ) agn\r\n                INNER JOIN (\r\n                    SELECT *\r\n                    FROM camAgenciasPrincipales\r\n                 ) agp\r\n                 INNER JOIN (\r\n                    SELECT *\r\n                    FROM camBrandsLogos\r\n                 ) brd\r\n                 ORDER BY AGN_AGP_Id";
    getAgenciasLogosJSON($sql);
}

コード例 #2

ファイル: index.php プロジェクト: hevelmo/compress

function getAgenciesTrucksPrincipales()
{
    $sql = "SELECT *\n                FROM (\n                    SELECT *\n                    FROM camAgencias\n                    WHERE AGN_Tipo = 1\n                    AND AGN_IsAgencieTrucks = 1\n                ) agn\n                INNER JOIN (\n                    SELECT *\n                    FROM camAgenciasPrincipales\n                 ) agp\n                 INNER JOIN (\n                    SELECT *\n                    FROM camBrandsLogos\n                 ) brd\n                 ORDER BY AGN_AGP_Id";
    getAgenciasLogosJSON($sql);
}