Shopping Cart Community

Code: Select all

$result = $GLOBALS['ISC_CLASS_DB']->Query("SELECT * FROM [|PREFIX|]brands ORDER BY brandname ASC");

Code: Select all

$result = $GLOBALS['ISC_CLASS_DB']->Query(" SELECT brandid,
                                                                   brandname,
                                                                   brandpagetitle,
                                                                   brandmetakeywords,
                                                                   brandmetadesc,
                                                                   brandimagefile,
                                                                   brandsearchkeywords
                                                            FROM   (SELECT prodname,
                                                                           Sum(prodvisible) AS total,
                                                                           prodbrandid
                                                                    FROM   [|PREFIX|]products
                                                                    GROUP  BY prodbrandid) AS checker
                                                                   JOIN [|PREFIX|]brands b
                                                                     ON b.brandid = prodbrandid
                                                            WHERE  total > 0
                                                            ORDER  BY brandname ASC");