PHP getCategoryByMarcJSON Examples

Example #1

File: index.php Project: hevelmo/compress

function getCategoryByMarc($idMrc)
{
    $sql = "SELECT MAR_Id, MAR_Nombre\r\n                FROM camSeminuevos sen\r\n                INNER JOIN camCategorias cat\r\n                ON sen.SEN_CAT_Id = cat.CAT_Id\r\n                INNER JOIN camMarcas mrc\r\n                ON sen.SEN_MAR_Id = mrc.MAR_Id\r\n                WHERE  SEN_CAT_Id = :idMrc\r\n                GROUP BY SEN_MAR_Id\r\n                ORDER BY MAR_Id\r\n                ";
    getCategoryByMarcJSON($sql, $idMrc);
}

Example #2

File: index.php Project: hevelmo/suzuki-lm-seminuevos

function getCategoryByMarc($idMrc)
{
    $sql = "SELECT MAR_Id, MAR_Nombre\r\n                FROM (\r\n                    SELECT *\r\n                    FROM v_camSeminuevos\r\n                    WHERE SEN_Status = 1\r\n                ) sen\r\n\t\t\t\tWHERE SEN_AGN_Id = 7\r\n                AND  SEN_CAT_Id = :idMrc\r\n                GROUP BY SEN_MAR_Id\r\n                ORDER BY MAR_Id";
    getCategoryByMarcJSON($sql, $idMrc);
}

Example #3

File: index.php Project: hevelmo/compress

function getCategoryByMarc($idMrc)
{
    $sql = "SELECT MAR_Id, MAR_Nombre\r\n                FROM v_camSeminuevos sen\r\n                WHERE  SEN_CAT_Id = 1\r\n                GROUP BY SEN_MAR_Id\r\n                ORDER BY MAR_Id";
    getCategoryByMarcJSON($sql, $idMrc);
}