ÎÒÓÃDreamweaver 8 ×öÍøÒ³£¬µ±×öµ½ÒªÏÔʾÊý¾Ý¿âÖеÄͼƬÊÇ£¬ÎÒÖ±ÏÈÌí¼ÓÁËÒ»¸ö¡°Í¼Ïñ¡±¿Ø¼þ£¬È»ºó½«Êý¾Ý¼¯¡°picture¡±Ö±½ÓÍϵ½¸Ã¿Ø¼þÉÏ£¬¿ªÊ¼²»ÄÜÏÔʾͼƬµÄ£¬ÎÒÓÚÊǽ«ÓйظÃÊý¾Ý¿âµÄͼƬ¸´ÖƵ½ÎÒ½¨Á¢µÄÕ¾µãµÄ¸ùĿ¼Ï£¬Í¼Æ¬¾ÍÄÜÏÔʾÁË£¡ÕâÑùÕæµÄºÜÂé·³£¬ÒòΪȫ²¿Í¼Æ¬¶¼·Åµ½Õ¾µãµÄ¸ùĿ¼»áµ¼ÖÂÕ¾µãÌ«ÔÓÂÒ£¬¡£ÎÒÏ뽫ͼƬµ¥¶À± ......
ÎÒ×ÔѧµÄD7£¬·¢ÏֺܻìÂÒ£¬ÌرðÊÇ·ÃÎÊACCESSµÄ·½·¨Óкö࣬ÀýÈç¿ÉÒÔÓÃadoconnection¿Ø¼þÁ¬½Ó¿â£¬»¹¿ÉÒÔÓÃ×Ö·û´®£¬Ôöɾ¸ÄµÄ·½Ê½Ò²ºÃ¼¸ÖÖ£¬¶¼²»ÖªµÀ¸ÃÓÃÄÄÖÖ·½·¨ÁË¡£
ÄÄλÄܸøÎÒµãÀý×Ó£º
ÐèÒªµÄÊÇÏÔʾ¼Ç¼¡¢Ìí¼Ó¼Ç¼¡¢É¾³ý¼Ç¼·½ÃæµÄ¡£
·Ç³£¸Ðл£¡
google,baidu ÀïÃæµ½´¦ÊÇ....ÚÀ
ÕÒÁ˼¸±¾Ê飬¶àÊýÊǽ²ÍϿؼþÈ»ºó×Ô¶¯Ö´ ......
ÎÒÏÖÔÚÏëʵÏÖÒ»ÏÂÕâÑùµÄ¹¦ÄÜ£º
ÔÚÎÒ±£´æ¼Ç¼֮ǰ£¬Ïȼì²éÒ»ÏÂÊý¾Ý¿âÖÐÊÇ·ñÒѾ´æÔÚͬÑùµÄ¼Ç¼£¬SQLÓïÑÔÓ¦¸ÃÔõôÑùд£¿£¨ADOQuery£©Á¬½ÓÊý¾Ý¿â¡£
ʹÓÃgroup by ij¼¸¸ö×ֶΠhaving count(*)>1 ¼´¿É
ÒýÓÃ
ʹÓÃgroup by ij¼¸¸ö×ֶΠhaving count(*)>1 ¼´¿É
count(*)>1µÄ»°,±íÖÐÒѾÓÐÖظ´µÄ¼Ç¼ÁË
Ò»°ãµÄ± ......
$conn = @new COM("ADODB.Connection") or die ("ADOÁ¬½Óʧ°Ü!");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("database.mdb");
$conn->Open($connstr);
$rs = @new COM("ADODB.RecordSet");
$sql ="select * from admin&quo ......
ÎÒÊÔÁËÏÂÕâ¸öÓï¾ä ÔÚsql server ÖÐÄÜͨ¹ýµÄ ÔÚaccessÖоͲ»ÐÐ
SELECT С°à.С°àºÅ as [С°à.С°àºÅ]
from С°à;
²»ÖªµÀÔõôÔÚAccessÖж¨Ò塰С°à.С°àºÅ¡±ÕâÑùµÄ×Ö¶ÎÃû
ACCESS²»ÔÊÐíÕâÑùÓï·¨
SQL code:
as [С°à.С°àºÅ]
SQL code:
as "С°à.С°àºÅ"
SQL code:
SELECT С°à.С°àºÅ as 'С°à. ......
<%if rs("tuijian")>0 then%>
<a href=admin_article.asp?action=tuijianno&id=<%=rs("id")%>><font color=red>ÊÇ</font></a>
<%else if rs("tuijian")=-1¡¡then%>
·ñ
<%else%& ......