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

mysql in²éѯ....

test.php  Ϊʲôȡ²»µ½Öµ£¿
PHP code:

<?php
mysql_connect("localhost","root","123456");
mysql_select_db("test");

$arr=array("1","2","3","5","10","6","9");
$query=mysql_query("select * from aaa where id in($arr)");//in("Êý×é")£¬Ã÷Á˵ÄÒâ˼---È¡µÃid=1¡¢2¡¢3...µÄÐÅÏ¢
while($result=mysql_fetch_array($query)){
echo $result[0]."<br>";
echo $result[1].""<br>;
}
?>




´íÎóÐÅÏ¢£ºmysql_fetch_array(): supplied argument is not a valid MySQL result resource .......
echo $query¿´Ò»ÏÂÓï¾ä¡£

PHP code:

$query=mysql_query("select * from aaa where id in('$arr')");



ÒýÓÃ
PHP code$query=mysql_query("select * from aaa where id in('$arr')");

µ¥ÒýºÅ£¬Ë«ÒýºÅ...¶¼ÊÔ¹ý£¬»¹ÊDz»ÐÐ- -£¡

ÄãÕæÓвţ¬Ö±½Ó°ÑÊý×é·Åµ½×Ö·û´®ÀïÈ¥
¸øÄãÌáʾÏ£¬ÓÃjoinº¯Êý

UP UP UP .......

ÒýÓÃ
ÄãÕæÓвţ¬Ö±½Ó°ÑÊý×é·Åµ½×Ö·û´®ÀïÈ¥
¸øÄãÌáʾÏ£¬ÓÃjoinº¯Êý

LZ»¹upʲô£¬¸Ï½ôÈ¥¸´Ï°sqlµÄinÓï¾ä£¬


Ïà¹ØÎÊ´ð£º

apache+PHP+mysqlÔÚwin7ÏÂʹÓÃ

ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£

win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£

µ±È»Äã×î ......

MySQLÊý¾Ý°ü¹ý´ó

ÎÒÓÃÒ»¸öÑ­»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ


public static final DataBase.MAXSIZE=102 ......

mysql´¢´æ¹ý³ÌµÄÎÊÌâ

ÎÒÏÖÔÚѧϰMYSQL£¬ÎÊÏÂmysql´¢´æ¹ý³ÌÈçºÎ½¨Á¢ºÍʹÓã¬×îºÃд³É$sql="sqlÓï¾ä",$re=mysql_query($sql);лл
½¨ÒéÄãÏÈ×Ô¼º¿´Ò»ÏÂÎĵµÖеÄÀý×Ó¡£

http://dev.mysql.com/doc/refman/5.1/zh/stored-pro ......

mysqlÁÙʱ±íµÄÎÊÌâ

ÎÒÎÊÏ£¬ÊDz»Êǽ¨Á¢ÁÙʱ±í±ØÐëºÍÖ÷±íµÄ×Ö¶Îʲô¶¼Ò»Ñù£¬²ÅÄÜÆð×÷Óðɣ¿»¹ÓÐÀïÃæÖ÷±íµÄÊý¾Ý¿âÊDz»ÊÇÒ²¾Í¸´ÖƵ½ÁÙʱ±íÁË£¬Èç¹ûÎÒselect Ö÷±í£¬²»ÓÃÔÚдselect ÁÙʱÁ˰ɣ¬ÊÇ×Ô¶¯¾ÍselectµÄÁÙʱÁ˰É?
ÎÒÎÊÏ£¬ÊDz»Êǽ¨Á ......

MYSQL±íµÄ´¦ÀíÎÊÌâ

Ò»ÕÅ±í £º ÐÕÃû  µØÖ·                      Éí·ÝÖ¤              ÐÔ±ð 
        ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ