<% strSql = "SELECT TOP 2 * FROM Graphic WHERE graphicCategoryId = 3 ORDER BY hit DESC" set rsTopOL = server.createObject("ADODB.recordSet") rsTopOL.open strSql,dbc,3,3 strSql = "SELECT TOP 5 * FROM Polyphonic ORDER BY hit DESC" set rsTopPolyphonic = server.createObject("ADODB.recordSet") rsTopPolyphonic.open strSql,dbc,3,3 strSql = "SELECT TOP 2 * FROM Graphic WHERE graphicCategoryId = 1 ORDER BY hit DESC" set rsTopWallpaper = server.createObject("ADODB.recordSet") rsTopWallpaper.open strSql,dbc,3,3 strSql = "SELECT TOP 2 * FROM Graphic WHERE graphicCategoryId = 2 ORDER BY hit DESC" set rsTopPM = server.createObject("ADODB.recordSet") rsTopPM.open strSql,dbc,3,3 strSql = "SELECT TOP 2 * FROM videoClip WHERE videoId = 2 ORDER BY inputDate DESC" set rsVideo = server.createObject("ADODB.recordSet") rsVideo.open strSql,dbc,3,3 strSql = "SELECT TOP 3 * FROM News WHERE newsCategoryId = 2 ORDER BY newsDate DESC" set rsNews = server.createObject("ADODB.recordSet") rsNews.open strSql,dbc,3,3 strSql = "SELECT TOP 3 * FROM News WHERE newsCategoryId = 1 ORDER BY newsDate DESC" set rsPress = server.createObject("ADODB.recordSet") rsPress.open strSql,dbc,3,3 strSql = "SELECT TOP 3 * FROM News WHERE newsCategoryId = 3 ORDER BY newsDate DESC" set rsMedia = server.createObject("ADODB.recordSet") rsMedia.open strSql,dbc,3,3 %>

-- Please Select -- Polyphonic Picture Messages Wallpaper   <%for i = 1 to 3 if (not rsMedia.eof) then%> <%rsMedia.MoveNext end if Next%> <%=formatDateTime(rsMedia("newsDate"),2)%> <%=rsMedia("media")%> <%=rsMedia("newsTitle")%> ">    <%for i = 1 to 3 if (not rsNews.eof) then%> <%rsNews.MoveNext end if next%> <%=formatDateTime(rsNews("newsDate"),2)%> <%=rsNews("newsTitle")%> ">    <%for i = 1 to 3 if (not rsPress.eof) then%> <%rsPress.MoveNext end if Next%> <%=formatDateTime(rsPress("newsDate"),2)%> <%=rsPress("newsTitle")%> ">    Dapatkan kumpulan klip video menarik dari koleksi funkyshow. Saksikan melalui streaming video dari web atau dari ponsel Nokia 7650 dan Nokia 3650 Anda. Berbagi kenangan indah dan peristiwa menarik Anda dengan sesama. Kirimkan foto ekspresi dan kegiatan Anda melalui MMS ke funkyboards dan ikuti kontes bulanan kami. Aneka download untuk mempercantik ponsel Anda. Dapatkan operator logo, picture message, wallpaper berwarna, ringtones polyphonic dan games menarik.

<% rsTopOL.close rsTopPolyphonic.close rsTopWallpaper.close rsTopPM.close rsVideo.close rsNews.close set rsTopOL = nothing set rsTopPolyphonic = nothing set rsTopWallpaper = nothing set rsTopPM = nothing set rsVideo = nothing set rsNews = nothing dbc.close set dbc = nothing %>