Get data from Database???

Hello,

I want help in php mysql.i have many category's & articles in Databse & i want get data by category,& i use this code

$result = $database->query("SELECT DISTINCT cat_title FROM category ORDER BY cat_title ASC");

HTML:

i got here all articale from all categoty but i want from spacifice one category so how to filter this please provide me code...


Thanks for all of supporters

 

its better to keep 2 tables.. do u know about normalization. for your problem if you need to get specific articles you need to provide category id
SELECT * from category where cat_id = "your cat id"

 

ya i got it...thanks mate its working