List Category and then each row under

[missmandino]

I am trying to update my faq page and right now every faq lists in order of category. However,I want to see each category listed and then each corresponding faq underneath for each category. How do I do this?

 

<? $result = sqlite_query($db, "SELECT * FROM faqs ORDER BY faqcategory DESC");

while($row = sqlite_fetch_array($result)) {?>

<ul>

<li><?php echo $row['faqquestion'];?></li>

</ul>

<p><?php echo $row['faqanswer']; ?></p>

 

Please help me- I am a total newbie!