Mysql query to show only active products. Please take a look

Discussion in 'MySQL' started by a4tech, Mar 25, 2013.

0
  1. #1
    Hello,

    I am looking for help to show only active products. This is mysql table code:

     $sql = "SELECT count(*) as total_product FROM insights_base";
    PHP:
    This is the mysql syntax that i try. But in out put in shows all Active and Inactive products. How to make it possible that it shows only Active products.

    Please help me that it shows only Active products and do not list Inactive products.
     
    Solved! View solution.
    Last edited: Mar 26, 2013
    a4tech, Mar 25, 2013 IP
  2. #2
    You should look into using PDO or mysqli as its so much more secure, mysql is soon to be deprecated.
    However if you must use mysql try this:

    $sql = "SELECT count(*) as total_product FROM insights_base where status='ACTIVE'";
    Code (markup):
     
    malky66, Mar 25, 2013 IP