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

MySQLÖвéѯÕý³££¬PHPÖÐÈ´±¨´í

Ô­ÌûµØÖ·ÊÇÕâÀ
http://topic.csdn.net/u/20091206/11/3c626084-5ecb-4489-a51d-058a963cb151.html

ÎÒÔÚMysqlÖвéѯÈçÏÂÓï¾äÊÇÕý³£µÄ£º
SQL code:
select w.author,sum(t.ct) sumnum
from writer w left join
(select t1.arcid,format(1/count(*),1) ct
from writer t1,content t2
where t1.arcid=t2.id and t2.islock=1
group by arcid) t
on w.arcid=t.arcid
group by w.author
order by sumnum desc
limit 30;



¶øÔÚPHPÖÐÔËÐУ¬È´±¨´íÈçÏ£º
SQL code:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') t ON w.arcid = t.arcid GROUP BY w.author limit 0,1' at line 5

²»ÖªµÀÊÇʲôÎÊÌ⣬Íû¸ßÊÖÖ¸½Ì£¬Ð»Ð»
Ê×ÏÈÅųöphpµÄ´íÎ󣡡«ÔÙÈ·¶¨ÊÇ·ñÕæµÄÕâÌõÓï¾ä²»ÄÜÔËÐеÄÎÊÌâ¡£ÓÐʱºòÄãÒª¿¼Âǵ½IE»º´æµÄÎÊÌâ¡£¹ØµôIEÖØÐÂÖ´ÐÐphpÒ³Ãæ


ΪʲôÄ㱨´íµÄÄÚÈݺÍsql²»Ò»ÑùÄØ
') t ON w.arcid = t.arcid GROUP BY w.author limit 0,1'

ÎҵijÌÐò»¹×Ô¼º±àÒëÒ»´Î£¬ÓõÄÊÇThinkPHP1.5

ÎÊÌâÒѾ­½â¾öÁË£¬ÊDZàÒëµÄʱºò£¬¶à¼ÓÁË»º´æ°²È«¼ì²é


Ïà¹ØÎÊ´ð£º

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

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

¸¶·ÑÇóÒ»¶Îphp´úÂ룬֧³ÖÌÔ±¦½»Ò×

¸÷λ´óЩ
ÇóÒ»¶Îphp´úÂë
¿ÉÒÔʵÏÖÒÔϹ¦ÄÜ
Õë¶Ô²»Í¬µÄä¯ÀÀÆ÷ÏÔʾ²»Í¬µÄͼƬ

¾ÍÊÇÓÐÒ»ÕÅͼƬ£¬Ö»Ïë¸øie6Óû§¿´µ½
Èç¹ûie7¡¢chrome¡¢firefoxÓû§ä¯ÀÀÔòÏÔʾÁíÍâÒ»ÕÅͼƬ

¼Û¸ñ²»ÒªÌ«ÀëÆ×¾ÍÐÐ ......

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

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

¿´Äã¶ÔÎļþȨÏÞµÄÉèÖÃ
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ