Category Filter - (Bookmarks)

CakePHP bookmarks

A list of the useful CakePHP web sites and related information that I have come across. These links will be updated as time permits...

Filed under: Bookmarks, Cakephp  

Customise your ajax loader spinners

Need a custom spinner? Quickly customise your spinners foreground and background colours...

Filed under: Bookmarks, Design  Tags: Ajax
(default) 9 queries took 9 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `posts`17171
2DESCRIBE `comments`11111
3DESCRIBE `tags`221
4DESCRIBE `categories`221
5DESCRIBE `posts_tags`221
6DESCRIBE `categories_posts`221
7SELECT Post.* FROM posts Post, categories_posts pc, categories c WHERE c.category = ('Bookmarks') AND c.id = pc.category_id AND pc.post_id = Post.id AND Post.status = 1 ORDER BY Post.created DESC221
8SELECT category, COUNT(*) AS cat_cnt FROM categories_posts c2p INNER JOIN categories Cat ON c2p.category_id = Cat.id GROUP BY category15151
9SELECT tag, COUNT(*) AS tag_cnt FROM posts_tags t2p INNER JOIN tags Tag ON t2p.tag_id = Tag.id GROUP BY tag49491