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

php sql¼Ó²éѯ±äÁ¿²»¿ÉÒÔ¸üÐÂ

top×Ö¶ÎΪsetÀàÐÍ×ֶΣ¬ÀïÃæ°üÀ¨Êý¾Ý¡±a,b,c,d,e¡°
$top = str_replace("c,","",str_replace(",c","",$row['top']));
$uptop = "update `biao1` set top='$top',topday ='0' where id=".$row['id'];
$up=mysql_query($uptop);

ÕâÑù¸üÐÂÖ»ÄܸüÐÂtopdayΪ0 µ«ÊDz»¿ÉÒÔ¸üÐÂtop×Ö¶ÎÀïÃæµÄÊý¾Ý£¬ÎÒÊÔÁË ÀïÃæÖ±½ÓÊäÈë×Ö·û¸üÐÂÒ²²»¿ÉÒÔ£¡
µ«ÊÇ¡±where id=".$row['id'];¡° ÕâÀïÖ±½Ó»»³É²éѯid¾Í¿ÉÒÔ¸üв»»»¾ÍÖ»ÄܸüÐÂtopdayÀïÃæÊý×ÖΪ0
¡±where id = 140";¡°ÕâÑù¾Í¿ÉÒÔÈ«²¿¸üРÇëÎÊÕâÊÇʲôÎÊÌ⣿ÒÔÉÏ´úÂëÔÚÒ»¸öforÑ­»·ÀïÃæÖ´Ðеģ¬ÅжÏÿÌõÐÅÏ¢ÊÇ·ñ·ûºÏÎÒ¶¨µÄÒªÇ󣬴ﵽ·ñÔòÖ´ÐÐÒÔÉÏ´úÂë

$uptop = "update `biao1` set top='$top',topday ='0' where id=".$row['id'];
echo $uptop
$up=mysql_query($uptop);


¿´Ò»ÏÂʵ¼ÊÄÚÈÝÊÇʲô£¿

ÒýÓÃ
$uptop = "update `biao1` set top='$top',topday ='0' where id=".$row['id'];
echo $uptop
$up=mysql_query($uptop);


¿´Ò»ÏÂʵ¼ÊÄÚÈÝÊÇʲô£¿


$row['top']ÀïÃæµÄÊý¾ÝÊÇ¡°a,b,c,d,e¡±
str_replace("c,","",str_replace(",c","",$row['top']));


°ÑÖ´ÐÐÓдíÎóµÄÇé¿öϵÄsql×Ö·û´®´òÓ¡¹©³öÀ´£¬Èç1Â¥µÄ·½·¨£¬È»ºóÔÚÊý¾Ý¿âÀïÃæÖ´ÐУ¬¿´¿´Äܲ»ÄÜÔËÐгɹ¦¡£¹À¼Æ»¹ÊÇsql×Ö·û´®ÓÐÎÊÌâ¡£
{{


Ïà¹ØÎÊ´ð£º

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

¿Õ¼äÉÏphpÎļþ²»ÄÜä¯ÀÀ£¬ä¯ÀÀ¾ÍÏÂÔØphpÎļþ

ÔÚ¹úÍâµÄ¿Õ¼ä£¬ÆäËüµÄphpÕ¾µã¶¼Õý³££¬¿ÉÖ»ÓÐ×î½ü½¨µÄÕâ¸öÕ¾µã£¬Ö»ÒªÒ»ä¯ÀÀphpÎļþ¾Í³öÏÖÏÂÔØÌáʾ£¬ÏÂÔØÏÂÀ´µÄÎļþ¶¼ÊÇ´øÓÐphpÔ´Â룬¸÷λ·¹ýµÄ£¬°ï°ïÎÒ£¬¿´¿´Ê²Ã´Ô­Òò£¬ÏÈлÁË¡£
¿Õ¼ä²»Ö§³Ö¡£
»òÕßÄãµÄÕ˺ÅûÓп ......

sqlÐÔÄÜÇóÖú - MS-SQL Server / ÒÉÄÑÎÊÌâ

³¡¾°ÈçÏ£º
¿Í»§°Ñ±¸·ÝºÃµÄÊý¾Ý¿â£¬·¢¸øÎÒ£¬ÎÒÔÚ±¾»ú»¹Ô­ºó£¬ÔËÐÐдºÃµÄ´æ´¢¹ý³Ì£¬±È½Ï¿ì£¬²¢ÇÒÔÚʵʩÄDZßÔËÐÐͬÑù±È½Ï¿ì¡£µ«Êǵ±ÊµÊ©ÔÚ¿Í»§ÄDZßÔËÐеÄʱºòËٶȾͷdz£µÄÂý£¬Ê±¼ä³¬³öÁ˳ÌÐòµÄʱ¼äÏÞÖÆ¡£Ô¶³ÌÔÚ¿Í»§ÄÇ ......

phpÎļþÄÜ·ñ±»±ðÈ˵ÁÈ¡?? - PHP / »ù´¡±à³Ì

ÎÒ¸ÕѧϰphpÇëÎÊ£¬Èç¹ûÎÒ°ÑphpÎļþÉÏ´«ÖÁ·þÎñÆ÷ºó£¬ÀýÈçhttp://www.****.com/cast.phpÕâ¸öÎļþ»á²»»á±»±ðÈËÏÂÔØ»ò¸´Öư¢£¿
¿ÉÒÔ±»ÏÂÔØ£¬Ò²¿ÉÒÔ²»±»ÏÂÔØ£¬¿´web·þÎñÆ÷¶Ô¸ÃÎļþȨÏÞµÄÅäÖÃ

¿´Äã¶ÔÎļþȨÏÞµÄÉèÖÃ
......

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ