sql select order by specific order

select * from tablename
Where id in (15,12,34,44,2)
Order by (Case When id = 15 then 0
When id = 12 then 1
When id = 34 then 2
When id = 44 then 3
When id = 2 then 4 Else id End)

coverflow effect

http://addyosmani.com/blog/jqueryuicoverflow/
http://www.deensoft.com/lab/protoflow/
http://blarnee.com/wp/an-improved-javascript-coverflow-demo-using-canvas-and-html5/
http://www.weberdesignlabs.com/blog/2007/09/flash-itunes-cover-flow/
http://jacksasylum.eu/ContentFlow/docu.php

CSS wide layout

to make the background going to wide of the site of any size of browser.

#wrapper{
width:100%; min-width:1200px;
position:relative;
}

scrolling vertical and horizontal

http://www.webdesignbooth.com/create-a-vertical-scrolling-news-ticker-with-jquery-and-jcarousel-lite/
http://sorgalla.com/jcarousel/

CSS hacks and techniques

http://www.catswhocode.com/blog/10-astonishing-css-hacks-and-techniques

Lightbox

http://www.zimbio.com/Interesting+webthings/articles/97/Web+2+0+Round+up+Modal+Window+Lightbox+Effect
http://www.hiddenpixels.com/designer-and-developer-resources/lightbox/
http://www.bugninja.com/code/rounded-corners-tooltip-lightbox-example/#
http://planetozh.com/projects/lightbox-clones/

Centering (horizontally and vertically) an image in a div box

<style type="text/css">
.wraptocenter {
display: table-cell;
text-align: center;
vertical-align: middle;
width: ...;
height: ...;
}
.wraptocenter * {
vertical-align: middle;
}
/*\*//*/
.wraptocenter {
display: block;
}
.wraptocenter span {
display: inline-block;
height: 100%;
width: 1px;
}
/**/
</style>
<!--[if lt IE 8]><style>
.wraptocenter span {
display: inline-block;
height: 100%;
}
</style><![endif]-->

And that’s the relevant HTML

<div class="wraptocenter"><span></span><img src="..." alt="..."></div>

http://www.brunildo.org/test/img_center.html

CSS Opacity

/* for IE */
filter:alpha(opacity=85) !important;
/* CSS3 standard */
opacity: 0.8;
-moz-opacity:1;
position:relative;

Clickable DIV

add onClick="window.location.href='http://www.google.com'"

Jquery Plugins

http://www.malsup.com/jquery/
http://slidesjs.com/ - slide show plugins
http://webdesignerwall.com/tutorials/jquery-tutorials-for-designers

back-and-forth scrolling effects

http://www.malsup.com/jquery/cycle/scrollhv.html
http://cssglobe.com/post/3783/jquery-plugin-easy-image-or-content-slider
http://www.ndoherty.biz/demos/coda-slider/
http://web.enavu.com/tutorials/making-a-nice-jquery-content-scroller-with-ease/

CSS Minimum Height

height:400px;
height:auto !important;

min-height:400px;

Thickbox

http://jquery.com/demo/thickbox/

Floating div on top and bottom

Top - http://roshanbh.com.np/2008/07/top-floating-message-box-using-jquery.html

Bottom - http://www.matto1990.com/jquery/catfish/

52 Blogs that Accept Guest Posts

http://piggybankpie.com/guest-blogging/52-blogs-that-accept-guest-posts/

http://www.hellboundbloggers.com/blogging/list-of-cool-blogs-to-write-guest-articles/

SEO Steps

Very useful tips on how to optimize a website.

1. Website analysis
2. Keyword Research
3. Adding Emphasis with Header Tags
4. Adding Emphasis with Tail Tags
5. Bold, Italic effect to main keywords
6. Canonicalization
7. Competition Analysis
8. CSS Validation
9. Google Base Feeds
10. H Tags Optimization (Eg: H1, H2, H3)
11. Header Tag Optimization
12. HTML Code Clean Up & Optimization
13. Image & Hyperlink Optimization
14. In depth site Analysis
15. Link Validation
16. Meta Description Tags Optimization
17. Meta Keywords Tags Optimization
18. Navigation & Design Optimization
19. PR Sculpting
20. Robots.txt Optimization
21. Text Modification Tags Optimization
22. Title Tag Optimization
23. URL Rewrite
24. W3C Validation
25. Working on HTML Source Code
26. Link Development
27. Authoritative Submissions
28. Broken Links Checking
29. Directory Submissions
30. Extraction of Site Url’s ( Link Level Depth)
31. Internal Link Structuring
32. Link Building ( Link Bait )
33. Manual Link Request to Related Sites
34. One way link (PR4 or Greater)
35. Site Back-links count
36. Local Search Engine Optimization
37. Custom Review Submission
38. h card Integration
39. Local Search Engine Submission
40. Testimonial Submission
41. Updating pages for local searches
42. Website Usability & Conversion
43. Being Webmaster Tools account setup & monitoring
44. Google Webmaster Tools account setup & monitoring
45. Installing Usability Tools on Website
46. Monthly Website Conversion Tracking
47. Optimization for Multiple Browsers
48. Article Submission
49. Blog Comment on Relevant Blogs
50. Blog Designing for the website
51. Blog Submission
52. Classified submission
53. Creating Promotional pages on hubpages, squidoo, etc
54. Face Book Twitter Marketing
55. Integration of page bookmarking tools
56. Integration of page sharing tools
57. Paid Submission
58. Photo Sharing
59. PPT Submission
60. Press Release
61. Product Indexing on Google Base
62. Rss Feeds
63. Social Bookmarking
64. Video Submission
65. Content Writing & Optimization
66. Article Writing
67. Blog Writing
68. Content Modification
69. Press Release Writing
70. Thematically Optimization of content pages
71. Website content writing through Latent Semantic Indexing
72. Website Spell Check
73. XML Site Map Creation & Submission
74. SE Saturation Checking ( Google, Yahoo & Bing)
75. Log file analysis
76. Google, Yahoo & Bing Site Map Creation
77. Google Analytics Funnel Creation
78. Google Analytics Account Setup
79. Deep Indexing Recommendations
80. Checking server response code for each URL
81. Check Search Engine Road Blocks
82. Check PR of each url

css Div height 100%

html {MIN-HEIGHT: 100%; HEIGHT: 100%}

body{
HEIGHT: 100%
}

#container{
min-height: 100%;
_height: 100%;
}

Hidden iframe injection attacks

Hidden iframe injection attacks

Limit Text and Strip tags in PHP

$content = $post->post_content;

$limit = 280;

if (strlen($content) > $limit)

$content = substr($content, 0, strrpos(substr($content, 0, $limit), ' ')) . '...';

echo strip_tags($content);

Javascript Validate Number Integer

IsFound = /^-?\d+$/.test($('number').value);

if (IsFound == false) {



$('error_msg').innerHTML = "* Please Enter a valid number.<br>";



}