Category Filter - (Javascript)

Dec 02, 2008
05:12

Geshi code to plain text JQuery javascript toggle

I was about to update my somewhat limited Geshi helper to handle more code types and to sort out the added character errors when pasting a copied code block when I stumbled upon Mark Story's Geshi Helper and took a look.

Marks code was super simple to use, the only real coding I did was to convert Marks MooTools javascript text toggle to JQuery...

Filed under: Cakephp, Javascript Tags: Jquery

(default) 3 queries took 4 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT Post.* FROM posts Post, categories_posts pc, categories c WHERE c.category = ('Javascript') AND c.id = pc.category_id AND pc.post_id = Post.id AND Post.status = 1 ORDER BY Post.created DESC	1	1	2
2	SELECT category, COUNT(*) AS cat_cnt FROM categories_posts c2p INNER JOIN categories Cat ON c2p.category_id = Cat.id GROUP BY category	15	15	1
3	SELECT tag, COUNT(*) AS tag_cnt FROM posts_tags t2p INNER JOIN tags Tag ON t2p.tag_id = Tag.id GROUP BY tag	49	49	1

(default) 3 queries took 4 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT Post.* FROM posts Post, categories_posts pc, categories c WHERE c.category = ('Javascript') AND c.id = pc.category_id AND pc.post_id = Post.id AND Post.status = 1 ORDER BY Post.created DESC

SELECT category, COUNT(*) AS cat_cnt FROM categories_posts c2p INNER JOIN categories Cat ON c2p.category_id = Cat.id GROUP BY category

SELECT tag, COUNT(*) AS tag_cnt FROM posts_tags t2p INNER JOIN tags Tag ON t2p.tag_id = Tag.id GROUP BY tag

Category Filter - (Javascript)

Geshi code to plain text JQuery javascript toggle

Categories

Tags

Site Sections

Blog Categories

Latest

Popular