Ãæ°ü»áÓеÄ

£¼%

'²âÊÔ¶ÁÈ¡MySqlÊý¾Ý¿âµÄÄÚÈÝ

strconnection="driver={mysql odbc 3.51 driver};database=weste_net;server=localhost;uid=root;password="

'ÎÞÐèÅäÖÃdsn

set adodataconn = server.createobject("adodb.connection")

adodataconn.open strconnection

strquery = "select * from News"

set rs = adodataconn.execute(strquery)

if not rs.bof then

%£¾

£¼table£¾

£¼tr£¾

£¼td£¼b£¾ÐòÁкţ¼/b£¾£¼/td£¾

£¼td£¾£¼b£¾±êÌ⣼/b£¾£¼/td£¾

£¼/tr£¾

£¼%

do while not rs.eof

%£¾

£¼tr£¾

£¼td£¾£¼%=rs("News_id")%£¾£¼/td£¾

£¼td£¾£¼%=rs("News_Title")%£¾£¼/td£¾

</tr>

<%

rs.movenext

loop

%£¾

</table>

<%

else

response.write("ÎÞÊý¾Ý.")

end if

rs.close

adodataconn.close

set adodataconn = nothing

set rsemaildata = nothing

%>