Featured post

c# - Usage of Server Side Controls in MVC Frame work -

i using asp.net 4.0 , mvc 2.0 web application. project requiremrnt have use server side control in application not possibl in noraml case. ideally want use adrotator control , datalist control. i saw few samples , references in codepleax mvc controllib howwver found less useful. can tell how utilize theese controls in asp.net application along mvc. note: please provide functionalities related adrotator , datalist controls not equivalent functionalities thanks in advace. mvc pages not use normal .net solution makes use of normal .net components impossible. a normal .net page use event driven solution call different methods service side mvc use actions , view completly different way handle things. also, mvc not use viewstate normal .net controlls require. found article discussing mixing of normal .net , mvc.

help me to write php code for this MySQL sql -


create table articles ( id integer not null primary key auto_increment , title varchar(99) not null , dateposted date not null , author varchar(99) not null ); create table article_rel ( this_article integer not null references articles (id) , related_article integer not null references articles (id)  , primary key (this_article,related_article) ); 

i building article site, want show related article. can write code articles table , scratching heads how article_rel table.

select   a.*   articles inner join   article_rel ar     on   ar.this_article = some_article_id_here     ,   ar.related_article = a.id 

brain fried, think it.


Comments

Popular posts from this blog

c# - Usage of Server Side Controls in MVC Frame work -

cocoa - Nesting arrays into NSDictionary object (Objective-C) -

ios - Very simple iPhone App crashes on UILabel settext -