仅在特定类别中显示项目[重复]

Question

This question already has an answer here:

• Is it better to filter a resultset using a WHERE clause or using application code? 3 answers

on my database i have a category, how do I display a specific category only to be display on my php page ?

<?
            include("conn.php");
            $result=mysql_query("select * from products");
            while($row=mysql_fetch_array($result)){
                if(@$count % 2==0){
        ?>
        <table border="0" cellpadding="2px" width="1000px">
<?php } ?>


            <td width="500"><img src="gambar/<?=$row['Gambar']?>" />
                <br><b><?=$row['product_name']?></b><br />
                    <?=$row['description_name']?><br />
                    Price:<big style="color:green">
                        RM<?=$row['price']?></big><br /><br />

the code above display all the item in the database.

</div>

Answer 1

Add where condition in query to filter Your result

 select * from products where category='books'