Line 14:
Line 15: var data = db.QuerySingle("SELECT * FROM Articles WHERE title =@0", article);
Line 16: var author = db.QuerySingle("SELECT FirstName, LastName, UserID, Image, ShortProfile, Profile FROM UserProfile WHERE UserID =@0", data.Author);
Line 17:
Line 18: var newslist = db.Query("SELECT TOP 7 ID, Title, Image, Date, Author FROM Articles WHERE Live = 'Yes' AND ID <> @0 ORDER BY Date Desc", data.ID);
|