Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÇóÒ»¸ösql Óï¾ä£¨asp£©

id lbname topid ceng
1 ²úÆ·1 0 1
16 ²úÆ·2 0 1
17 ²úÆ·3 0 1
18 ²úÆ·4 0 1
19 ²úÆ·5 0 1
20 ²úÆ·6 0 1
21 ²úÆ·7 0 1
22 ²úÆ·8 0 1
23 ²úÆ·9 0 1
24 ²úÆ·10 0 1
25 ²úÆ·11 0 1
33 ²úÆ·12 1 2
34 ²úÆ·13 1 2
35 ²úÆ·14 34 3

ÒÔÉÏÊÇÒ»¸ö±í£¬ÒÑÖªid=35£¬ÈçºÎÕÒµ½Í¨¹ýtopid=34ÕÒµ½id=1£¬Çë¸ßÊֻشð£¬Ð»Ð»
id=1,id=35ûÓÐʲô¹ØÏµÑ½

ÒýÓÃ
id=1,id=35ûÓÐʲô¹ØÏµÑ½


Ò»¹²ÓÐ4¸ö×ֶΣ¬Ö»ÊÇÏÂÃæÃ»¶ÔÆë£¬Äã×Ðϸ¿´Ï¾ÍÖªµÀÁË

topid=34¶ÔÓ¦µÄidÊÇ35£¬¶øÕâÐÐÊý¾ÝºÍid=1ûÓйØÏµÑ½



Ïà¹ØÎÊ´ð£º

ÎâÀÏʦÔÚÂ𣿠ÎÊÒ»¸öasp ´«²ÎÊýµÄÎÊÌâ

dim idi=request.QueryString("id")
set rs=server.createobject("adodb.recordset")




rs.open"select * from fang where id=194",conn,1,1
%>
......

asp Êý¾Ý²åÈëÎÊÌâ request.formÎÊÌâ

ÎҵĸùĿ¼ÊÇweb ÉÏ´«ÎļþÊÇweb/index.asp  Êý¾Ý¿âÊÇweb/Data/Magic.mdb Êý¾Ý¿âÖÐÓиö±ípic  ±íÖÐÓÐ×Ö¶Îpicname¡¢username¡¢Addtime¡¢addname¡¢location¡¢pp

×Ö¶ÎpicnameÄܲåÈëÊý¾Ý¡¢×Ö¶ÎlocationÒ ......

ASPÁ¬½ÓMySQL³ö´í ¼±

ÎÒ×öÁËÒ»¸öASPÍøÕ¾£¨µÚÒ»´Î×ö£©£º
ÔÚÎÒµçÄÔÉÏ£¬ÎÒÏÂÁ˸öMySQLµÄODBC£¬
Á¬½ÓÓï¾ä£º
ConnStr = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=127.0.0.1;DATABASE=test;USER=root;PASSWORD=123456;"
......

asp·ÖÒ³

<!--#include file="Conn.asp"-->
<body>
<table border="0" align="left" cellpadding="0" cellspacing="0">
<%

URL ......

ASP ×ֶαȽÏ

´ÓAcessÊý¾Ý¿âÀï²éÕÒµ½Ä³Ò»Ìõ¼Ç¼£¬Òª±È½ÏÕâÌõ¼Ç¼ÖеÄijһÁеÄÖµÊÇ·ñ°üº¬Ä³Ò»×ֶΡ£
±ÈÈ磬Êý¾Ý¶ÔËùÓеÄÓû§²Ù×÷½øÐÐÁ˼Ǽ¡£
ÔÚÈÕÖ¾²éѯÀÏë°ÑÓû§É¾³ý¼Ç¼ÒÔºìÉ«ÐÅÏ¢ÏÔʾ¡£
ÿÌõɾ³ýµÄÈÕÖ¾¼Ç¼ÀïÓÐÒ»Á ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ