hi,
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?
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?