Gossamer Forum
Quote Reply
news related to category

first, please excuse my bad english.

i have a table with news (lsql_px_items) and another table with the corresponding categories (lsql_px_feeds).

table structure:
lsql_px_items: id, feed_id, title, content, date
lsql_px_feeds: id, title, dlink

now, i want to show in every links category (ex. finance) all news with the term "finance" - also "Name" in title or content. the link should go to the news category (http://abc.com/news/dlink.php) and the sort order should be "date" desc.

is that possible?

Last edited by:

regatta: Feb 17, 2007, 7:40 PM