ok, guys my most recent trouble is the following. i have 3 tables:
ds_search for links (fields: lid for link id, title for link title etc.)
ds_categories for categories (fields: cat_id for category id, name for category name, etc.)
ds_link_cat which joins above 2 (fields: lid matching with ds_search's lid, category that matches cat_id in ds_categories)
now, toward my goal. i wish to have last 10 links pulled from ds_search and show them under their categories. example.
Politics
Clintons sends a thanksgiving card to Bin laden.
Sports
Putin wins Bush 3 to 0.
is this something possible? if yes, please, Please give me the complete code, i am too newbie to sql.
thanks
Arman Galstyan
eNotalone.com
