Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Óï¾ä£¬


Ïà¹ØÎÊ´ð£º

mysqlµÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

ÎÒÒª°Ñ×¢²áÐÅÏ¢Ìá½»µ½mysqlÖУ¬ÒªÔõô°ìÄØ£¿

ÎÒÔÚ×¢²áÒ³ÃæÐ´ÈëÁËÈçÏ´úÂ룺
<?php
    $conn=mysql_connect("localhost","root","614510")or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Ó´íÎó".mysql_error());
& ......

MYSQL Êý¾Ý½ØÈ¡

MYSQL ½ØÈ¡Ò»¸öÊý¾Ý±íÖÐ,ijһ¸ö×Ö¶Î(fulltext) µÄǰÈý°Ù¸ö×Ö·û,·Åµ½¸Ã±íÏÂÁíÒ»¸ö×Ö¶Î(introtxt)Àï.
ÇóʵÏÖÕâ¸öЧ¹ûµÄÃüÁî
SQL code:
update ±í set introtxt=left(`fulltext`,300);

¶¥£¬Ñ§Ï°

SQL code: ......

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

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