PHP getBrandsLogosJSON Examples

Example #1

File: index.php Project: hevelmo/compress

function getBrandsLogos()
{
    $sql = "SELECT *\r\n                FROM (\r\n                    SELECT *\r\n                    FROM camBrandsLogos\r\n                ) brd\r\n                LEFT JOIN (\r\n                    SELECT *\r\n                    FROM camAgencias\r\n                ) agn\r\n                ON agn.AGN_AGP_Id = brd.BRD_AGP_Id\r\n                LEFT JOIN (\r\n                    SELECT *\r\n                    FROM camAgenciasPrincipales\r\n                ) agp\r\n                ON agn.AGN_AGP_Id = agp.AGP_Id\r\n                GROUP BY BRD_Id\r\n                ";
    getBrandsLogosJSON($sql);
}

Example #2

File: index.php Project: hevelmo/compress

function getBrandsLogos()
{
    $sql = "SELECT *\n                FROM (\n                    SELECT *\n                    FROM camBrandsLogos\n                    WHERE BRD_Status = 1\n                ) brd\n                LEFT JOIN (\n                    SELECT *\n                    FROM camAgencias\n                ) agn\n                ON agn.AGN_AGP_Id = brd.BRD_AGP_Id\n                LEFT JOIN (\n                    SELECT *\n                    FROM camAgenciasPrincipales\n                ) agp\n                ON agn.AGN_AGP_Id = agp.AGP_Id\n                GROUP BY BRD_Id\n                ORDER BY BRD_Index\n                ";
    getBrandsLogosJSON($sql);
}