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,30,29,28,27,26,25) GROUP BY ID

Open AJAX

Programming Cheat Sheets

July 26th, 2006

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';

Comments Off

JSLint and JSMin

July 25th, 2006

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'

No Comments »

AJAX Frameworks

July 25th, 2006

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'

No Comments »

Standard AJAX, VB, and Windows 3.1

July 25th, 2006

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'

No Comments »

XML11 vs GWT

June 28th, 2006

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 = 30 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 = '30' AND comment_approved = '1'

No Comments »

Buttonator

May 19th, 2006

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 = 29 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 = '29' AND comment_approved = '1'

No Comments »

“Global Mosaic”, a massively multiplayer Web 2.0 application

April 28th, 2006

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 = 28 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 = '28' AND comment_approved = '1'

No Comments »

Google Calendar - Right on Time!

April 13th, 2006

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 = 27 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 = '27' AND comment_approved = '1'

No Comments »

Office for Firefox and Google Pages

March 23rd, 2006

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 = 26 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 = '26' AND comment_approved = '1'

No Comments »

Google Finance

March 21st, 2006

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 = 25 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 = '25' AND comment_approved = '1'

No Comments »