SQL Display a News Article from a selected category

Hi Guys,

Can someone help me. I am using FCK Editor when I add a new news article to my website. When entering each new article, I have included an option where there is a drop-down list to select a particular news category.

In the front-end of the website the news page displays all news articles from all categories, even if I select a different category for each news article.

My problem is I am stuck on how to display news articles from only the selected category when adding a new article. A solution would enable me to display a news article from any particular news category on any webpage on my website and display another news article from a different category on a different web page.

I suspect it may be a problem with the SQL statement in the content-news code, but I'm not sure as I am not too good at SQL statements. See attached files.

Can anyone help me out?

 

The problem has to be in your code
The editor you are using is just a wysiwyg text editor
Are you using a script (PHP or Java)
can you give us a link to the page
we can check the code (HTML, CSS, javascript) and give you some suggestions
-
falcon