| Senaste nyheterna för Malmhaug (ej lag): |
<%
Dim rsNews
Dim strNews, strDatum
' flytta till Nyheter:
strNews = "SELECT * FROM `tblNews` WHERE TeamID = 1 ORDER BY newsDate DESC LIMIT 5"
Set rsNews = malmhaugRS(strNews)
If rsNews.EOF Or rsNews.BOF Then
Response.Write "Inga nyheter för tillfället"
Else
Do while not rsNews.EOF
strDatum = FormatDateTime(rsNews("NewsDate"), vbShortDate) & " kl " & FormatDateTime(rsNews("NewsDate"), vbShortTime)
strDatum = Replace(strDatum, "/", "-")
Response.Write " " & rsNews("headLine") & " | " & strDatum & " | "
rsNews.MoveNext
Loop
End If
CloseDB(rsNews)
%>
|