WordPress database error: [Table './openajax/wp_comments' is marked as crashed and should be repaired]
SELECT ID, COUNT( comment_ID ) AS ccount
FROM wp_posts
LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1')
WHERE ID IN (35,33,32,31)
GROUP BY ID
This site has a huge list of programming cheat sheets - not directly AJAX related, however, you have to write code to work with AJAX… :
WordPress database error: [Table './openajax/wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 35 AND comment_approved = '1';
It recently came to our attention that not everyone knows about two critical free tools for any type of AJAX development.
http://www.jslint.com/lint.html
http://www.crockford.com/javascript/jsmin.html
JSMin is a tool for compressing Javascript. It will strip your white-space and comments so that all that is left is code….you know, the good stuff. It does not obfuscate the code, just […]
WordPress database error: [Table './openajax/wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 33 AND comment_approved = '1';
WordPress database error: [Table './openajax/wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '33' AND comment_approved = '1'
ajaxpatterns.org has a nice listing of AJAX frameworks; everythign from .Net to Coldfusion, from Java to Smalltalk and C++.
http://ajaxpatterns.org/Ajax_Frameworks
There is even the beginnings of a Comparison Matrix.
WordPress database error: [Table './openajax/wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 32 AND comment_approved = '1';
WordPress database error: [Table './openajax/wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '32' AND comment_approved = '1'
Years ago, Adam Bosworth coined the term DHTML - as in Dynamic HTML. Jesse James Garrett re-labeled DHTML as “AJAX” If you have not seen this clip - you should. Watch it and pay close attention to what is said, as well as what is not said. Notice that AJAX is […]
WordPress database error: [Table './openajax/wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 31 AND comment_approved = '1';
WordPress database error: [Table './openajax/wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '31' AND comment_approved = '1'
RSS Feeds 
You are currently browsing the Open AJAX weblog archives for July, 2006.