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´úÂë
¿ÉÒÔʵÏÖÒÔϹ¦ÄÜ
Õë¶Ô²»Í¬µÄä¯ÀÀÆ÷ÏÔʾ²»Í¬µÄͼƬ
¾ÍÊÇÓÐÒ»ÕÅͼƬ£¬Ö»Ïë¸øie6Óû§¿´µ½
Èç¹ûie7¡¢chrome¡¢firefoxÓû§ä¯ÀÀÔòÏÔʾÁíÍâÒ»ÕÅͼƬ
¼Û¸ñ²»ÒªÌ«ÀëÆ×¾ÍÐÐ ......
ÎÒ¸ÕѧϰphpÇëÎÊ£¬Èç¹ûÎÒ°ÑphpÎļþÉÏ´«ÖÁ·þÎñÆ÷ºó£¬ÀýÈçhttp://www.****.com/cast.phpÕâ¸öÎļþ»á²»»á±»±ðÈËÏÂÔØ»ò¸´Öư¢£¿
¿ÉÒÔ±»ÏÂÔØ£¬Ò²¿ÉÒÔ²»±»ÏÂÔØ£¬¿´web·þÎñÆ÷¶Ô¸ÃÎļþȨÏÞµÄÅäÖÃ
¿´Äã¶ÔÎļþȨÏÞµÄÉèÖÃ
......