Exemplo n.º 1
0
function getAgenciesNews()
{
    $sql = "SELECT *\r\n                FROM camAgenciasNuevos agm\r\n                ";
    getAgenciesNewsJSON($sql, '', '');
}
Exemplo n.º 2
0
function getAgenciesNewsById($agpid)
{
    $sql = "SELECT *\r\n                    FROM (\r\n                        SELECT *\r\n                        FROM camAgencias\r\n                        WHERE AGN_Tipo = 1\r\n                        AND AGN_AGP_Id = :agpid\r\n                    ) agn\r\n                    INNER JOIN camAgenciasPrincipales agp\r\n                    ON agn.AGN_AGP_Id = agp.AGP_Id\r\n                    ";
    getAgenciesNewsJSON($sql, $agpid);
}
Exemplo n.º 3
0
function getAgenciesNews()
{
    $sql = "SELECT *\r\n                FROM (\r\n                    SELECT *\r\n                    FROM camAgencias\r\n                    WHERE AGN_Tipo = 1\r\n                ) agn";
    getAgenciesNewsJSON($sql, '', '');
}