<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:georss='http://www.georss.org/georss' xmlns:gd='http://schemas.google.com/g/2005' xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-5914500912012912214</id><updated>2011-11-28T05:50:11.241+06:00</updated><category term='jquery'/><category term='group_concat()'/><category term='break'/><category term='Rickshawala'/><category term='N-tier architecture'/><category term='MySQL'/><category term='MVC'/><category term='SEO'/><category term='continue'/><category term='gmail'/><category term='aggregate function'/><title type='text'>Itty-Bitty Talks</title><subtitle type='html'>Small Tech Talks By RON</subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://boyron.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5914500912012912214/posts/default?max-results=100'/><link rel='alternate' type='text/html' href='http://boyron.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>Mahbub-E-Elahi Ron</name><uri>http://www.blogger.com/profile/03360756520916516087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='31' src='http://bp0.blogger.com/_1UJtnTLSZB8/R3YH45i512I/AAAAAAAAACc/qJ9LbVSIpso/S220/ron.jpg'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>7</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>100</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-5914500912012912214.post-3050732922073968049</id><published>2009-05-21T20:28:00.002+06:00</published><updated>2009-05-21T20:45:35.982+06:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='break'/><category scheme='http://www.blogger.com/atom/ns#' term='jquery'/><category scheme='http://www.blogger.com/atom/ns#' term='continue'/><title type='text'>‘break’ and ‘continue’ for jQuery loop</title><content type='html'>&lt;p&gt;&lt;br /&gt;    jQuery functions like $.each( &lt;span title="A simple Javascript object.."&gt; &lt;/span&gt;Object &lt;span title="The object, or array, to iterate over."&gt; &lt;/span&gt;obj, &lt;span title="A reference to a Javascript function."&gt; &lt;/span&gt;Function &lt;span title="The function that will be executed on every object."&gt; &lt;/span&gt;fn ) or $().each() are not  loop rather these are iterative functions. $().each() is used to iterate over a  jQuery object and you can use $.each( &lt;span title="A simple Javascript object.."&gt; &lt;/span&gt;Object &lt;span title="The object, or array, to iterate over."&gt; &lt;/span&gt;obj, &lt;span title="A reference to a Javascript function."&gt; &lt;/span&gt;Function &lt;span title="The function that will be executed on every object."&gt; &lt;/span&gt;fn ) to iterate over anything (for  example, an array). As they iterate over something we call them loop.&lt;/p&gt;&lt;br /&gt;    &lt;p&gt;So jQuery loops are not like javascript  loops.&lt;/p&gt;&lt;br /&gt;    &lt;p&gt;We use &amp;lsquo;break;&amp;rsquo; and &amp;lsquo;continue;&amp;rsquo; inside a  loop. These will not work inside a jQuery loop (like $.each()). So what you  will do, if you need the same functionality for a jQuery loop. Fortuitously there is another way. You can use &amp;lsquo;return false;&amp;rsquo; inside  a jQuery loop to break it. The idea is simple. jQuery loops are functions. So when  you &amp;lsquo;return false;&amp;rsquo; from a function, it will immediately stop execution of that  function and will not continue. Which will work as &amp;lsquo;break;&amp;rsquo;. Similarly if you  write &amp;lsquo;return;&amp;rsquo; (without an argument) it will work as &amp;lsquo;continue&amp;rsquo;;&lt;/p&gt;&lt;br /&gt;    &lt;p&gt;Here are two examples:-&lt;/p&gt;&lt;br /&gt; &lt;p&gt;&lt;code&gt;&lt;br /&gt;    $(&amp;quot;#tblId tr&amp;quot;).each(function(i, obj) {&lt;br /&gt;&lt;br /&gt;    &amp;nbsp;&amp;nbsp;&amp;nbsp; If($(obj).attr('id')==&amp;rsquo;idBreakHere&amp;rsquo;)  {&lt;br /&gt;&lt;br /&gt;    &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;return false; //this is equivalent of 'break' for jQuery  loop&lt;br /&gt;&lt;br /&gt;    &amp;nbsp;&amp;nbsp;&amp;nbsp; }&lt;br /&gt;&lt;br /&gt;    }&lt;/code&gt;&lt;/p&gt;&lt;br /&gt; &lt;p&gt;&lt;code&gt;&lt;br /&gt;    $(&amp;quot;#tblId tr&amp;quot;).each(function(i, obj) {&lt;br /&gt;&lt;br /&gt;    &amp;nbsp;&amp;nbsp;&amp;nbsp; If($(obj).attr('id')!=&amp;rsquo;idToFind&amp;rsquo;)  {&lt;br /&gt;&lt;br /&gt;    &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;return; //this is equivalent of 'continue' for jQuery  loop&lt;br /&gt;&lt;br /&gt;    &amp;nbsp;&amp;nbsp;&amp;nbsp; }&lt;br /&gt;&lt;br /&gt;    }&lt;/code&gt;&lt;/p&gt;&lt;br /&gt; &lt;p&gt;&lt;br /&gt;    Cheers,&lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-7708895815698503";
google_ad_width = 728;
google_ad_height = 15;
google_ad_format = "728x15_0ads_al";
google_ad_channel = "";
google_color_border = "FFFFFF";
google_color_bg = "FFFFFF";
google_color_link = "99C9FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5914500912012912214-3050732922073968049?l=boyron.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://boyron.blogspot.com/feeds/3050732922073968049/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5914500912012912214&amp;postID=3050732922073968049' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5914500912012912214/posts/default/3050732922073968049'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5914500912012912214/posts/default/3050732922073968049'/><link rel='alternate' type='text/html' href='http://boyron.blogspot.com/2009/05/break-and-continue-for-jquery-loop.html' title='‘break’ and ‘continue’ for jQuery loop'/><author><name>Mahbub-E-Elahi Ron</name><uri>http://www.blogger.com/profile/03360756520916516087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='31' src='http://bp0.blogger.com/_1UJtnTLSZB8/R3YH45i512I/AAAAAAAAACc/qJ9LbVSIpso/S220/ron.jpg'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5914500912012912214.post-8768542835201097747</id><published>2008-07-10T14:07:00.001+06:00</published><updated>2008-07-10T14:12:55.613+06:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='gmail'/><title type='text'>Who is hacking your gmail account?</title><content type='html'>Don't forget to see the footer each time you see your gmail inbox!&lt;br /&gt;Read more..&lt;br /&gt;&lt;a href="http://gmailblog.blogspot.com/2008/07/remote-sign-out-and-info-to-help-you.html"&gt;Official Gmail Blog: Remote sign out and info to help you protect your Gmail account&lt;/a&gt;&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-7708895815698503";
google_ad_width = 728;
google_ad_height = 15;
google_ad_format = "728x15_0ads_al";
google_ad_channel = "";
google_color_border = "FFFFFF";
google_color_bg = "FFFFFF";
google_color_link = "99C9FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5914500912012912214-8768542835201097747?l=boyron.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='related' href='http://gmailblog.blogspot.com/2008/07/remote-sign-out-and-info-to-help-you.html' title='Who is hacking your gmail account?'/><link rel='replies' type='application/atom+xml' href='http://boyron.blogspot.com/feeds/8768542835201097747/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5914500912012912214&amp;postID=8768542835201097747' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5914500912012912214/posts/default/8768542835201097747'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5914500912012912214/posts/default/8768542835201097747'/><link rel='alternate' type='text/html' href='http://boyron.blogspot.com/2008/07/official-gmail-blog-remote-sign-out-and.html' title='Who is hacking your gmail account?'/><author><name>Mahbub-E-Elahi Ron</name><uri>http://www.blogger.com/profile/03360756520916516087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='31' src='http://bp0.blogger.com/_1UJtnTLSZB8/R3YH45i512I/AAAAAAAAACc/qJ9LbVSIpso/S220/ron.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5914500912012912214.post-7699386634213871817</id><published>2007-12-20T15:58:00.000+06:00</published><updated>2007-12-20T16:48:20.880+06:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='MVC'/><category scheme='http://www.blogger.com/atom/ns#' term='N-tier architecture'/><title type='text'>Is 3 tier architecture and MVC same?</title><content type='html'>Today, Rishan (sommohon) ask me this question while chatting with him. I gave him the answer in one sentence but I myself was not satisfied with the answer. I thought I should write something about this in short.&lt;br /&gt;&lt;br /&gt;After a long period I am writing to my blog. As I am in vacation right now at last I got some time to write something. I can continue writing if you guys help me by requesting topics to discuss and also post reply to this topics.&lt;br /&gt;&lt;br /&gt;Now what is the answer.&lt;br /&gt;&lt;br /&gt;If you say yes, I think that is correct. If you say no, I think that is also correct. You wonder how? Let’s see the simple similarities and dissimilarities.&lt;br /&gt;&lt;br /&gt;Both n-tier architecture and MVC have the same root, or same basic idea that they separate the responsibilities among different parties to make your application more robust, more flexible, more scalable and easier maintainable.&lt;br /&gt;&lt;br /&gt;MVC is a design pattern for GUI. A design pattern shows us how to separate responsibilities between VIEW and DATA at the presentation tier. Most web application framework is based on the MVC pattern (MVC Model 2).&lt;br /&gt;&lt;br /&gt;N-tier architecture is about how to design your application or system architecture pattern, the basic idea is to separate the responsibilities among different tiers (Presentation tier responsible for UI or User Interface, BL or Business Logic tier responsible for business logic, DAL or Data Access Layer tier responsible for data, Service layer for Service etc.)&lt;br /&gt;&lt;br /&gt;So about MVC and N-tier we can say that concepts are same but implementation is different. This is my simple understanding.&lt;br /&gt;&lt;br /&gt;I hope to learn and write about this more. Any comments or suggestions?&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-7708895815698503";
google_ad_width = 728;
google_ad_height = 15;
google_ad_format = "728x15_0ads_al";
google_ad_channel = "";
google_color_border = "FFFFFF";
google_color_bg = "FFFFFF";
google_color_link = "99C9FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5914500912012912214-7699386634213871817?l=boyron.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://boyron.blogspot.com/feeds/7699386634213871817/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5914500912012912214&amp;postID=7699386634213871817' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5914500912012912214/posts/default/7699386634213871817'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5914500912012912214/posts/default/7699386634213871817'/><link rel='alternate' type='text/html' href='http://boyron.blogspot.com/2007/12/is-3-tier-architecture-and-mvc-same.html' title='Is 3 tier architecture and MVC same?'/><author><name>Mahbub-E-Elahi Ron</name><uri>http://www.blogger.com/profile/03360756520916516087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='31' src='http://bp0.blogger.com/_1UJtnTLSZB8/R3YH45i512I/AAAAAAAAACc/qJ9LbVSIpso/S220/ron.jpg'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5914500912012912214.post-8204541749810297908</id><published>2007-05-03T12:07:00.000+06:00</published><updated>2008-12-13T14:44:00.071+06:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='gmail'/><title type='text'>[Google Tips]: Use Gmail as a Hard Drive</title><content type='html'>Gmail is providing you more than 2 GB space. So, why not  to use this space? You can use Gmail as a network drive on your PC. Yes!&lt;br /&gt;&lt;p&gt;It looks and feels just a regular hard drive. And it’s as  simple to use as you might hope, if you are Windows user.&lt;br /&gt;&lt;br /&gt;Go to &lt;a href="http://www.viksoe.dk/code/gmail.htm" target="_blank"&gt;http://www.viksoe.dk/code/gmail.htm&lt;/a&gt; and download a copy of GMail Drive. After  downloading extract and install the files. You will see a GMail Drive in your My Computer. Click on  that drive and you will be prompted for login as show in the picture:-&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/_1UJtnTLSZB8/Rjl8-iUcx1I/AAAAAAAAAAM/mpK2etS721I/s1600-h/gmail_drive_login.JPG"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer;" src="http://2.bp.blogspot.com/_1UJtnTLSZB8/Rjl8-iUcx1I/AAAAAAAAAAM/mpK2etS721I/s320/gmail_drive_login.JPG" alt="" id="BLOGGER_PHOTO_ID_5060213070133774162" border="0" /&gt;&lt;/a&gt;&lt;/p&gt;&lt;p&gt;  Copy and  paste your files from your local hard drive to GMail Drive.&lt;br /&gt;&lt;/p&gt;&lt;div style="text-align: center;"&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/_1UJtnTLSZB8/RjmAZiUcx2I/AAAAAAAAAAU/CL2c869DlXE/s1600-h/gmail_drive.JPG"&gt;&lt;img style="cursor: pointer;" src="http://2.bp.blogspot.com/_1UJtnTLSZB8/RjmAZiUcx2I/AAAAAAAAAAU/CL2c869DlXE/s320/gmail_drive.JPG" alt="" id="BLOGGER_PHOTO_ID_5060216832525125474" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;/div&gt;&lt;p&gt;And your  files will appear in your gmail inbox as mails.&lt;br /&gt;&lt;/p&gt;&lt;div style="text-align: center;"&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://1.bp.blogspot.com/_1UJtnTLSZB8/RjmAoSUcx3I/AAAAAAAAAAc/gcMUBUX9254/s1600-h/gmail_drive_files_in_gmail.JPG"&gt;&lt;img style="cursor: pointer;" src="http://1.bp.blogspot.com/_1UJtnTLSZB8/RjmAoSUcx3I/AAAAAAAAAAc/gcMUBUX9254/s320/gmail_drive_files_in_gmail.JPG" alt="" id="BLOGGER_PHOTO_ID_5060217085928195954" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;/div&gt;&lt;p&gt;Happy  GMailing to all Googlians!&lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-7708895815698503";
google_ad_width = 728;
google_ad_height = 15;
google_ad_format = "728x15_0ads_al";
google_ad_channel = "";
google_color_border = "FFFFFF";
google_color_bg = "FFFFFF";
google_color_link = "99C9FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5914500912012912214-8204541749810297908?l=boyron.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://boyron.blogspot.com/feeds/8204541749810297908/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5914500912012912214&amp;postID=8204541749810297908' title='6 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5914500912012912214/posts/default/8204541749810297908'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5914500912012912214/posts/default/8204541749810297908'/><link rel='alternate' type='text/html' href='http://boyron.blogspot.com/2007/05/google-tips-use-gmail-as-hard-drive.html' title='[Google Tips]: Use Gmail as a Hard Drive'/><author><name>Mahbub-E-Elahi Ron</name><uri>http://www.blogger.com/profile/03360756520916516087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='31' src='http://bp0.blogger.com/_1UJtnTLSZB8/R3YH45i512I/AAAAAAAAACc/qJ9LbVSIpso/S220/ron.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://2.bp.blogspot.com/_1UJtnTLSZB8/Rjl8-iUcx1I/AAAAAAAAAAM/mpK2etS721I/s72-c/gmail_drive_login.JPG' height='72' width='72'/><thr:total>6</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5914500912012912214.post-303443213400383776</id><published>2007-04-30T11:23:00.000+06:00</published><updated>2007-05-01T13:20:34.244+06:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Rickshawala'/><title type='text'>Rickshawala</title><content type='html'>I usually travel by bus while returning from office. There are two ways to return from my office to home. There is a direct bus service from Gulshan-2 to Mohammadpur. And another way is to take 27 no bus from Kakoli upto Asad gate then the rest to Mohammadpur by Rickshaw. My office is at Banani 27 no road, middle of Gulshan 2 and Kakoli.&lt;br /&gt;&lt;br /&gt;Yesterday I took the second way. From Asad gate I took a Rickshaw. I rode on the rickshaw and asked the rickshawala, &lt;span style="font-style: italic;"&gt;‘What is the fare upto Mohammadpur Shiya Mosque?’&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-style: italic;"&gt;’15 taka’&lt;/span&gt;, he replied.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-style: italic;"&gt;‘It should be 12 taka, why you are charging more?’&lt;br /&gt;&lt;br /&gt;&lt;/span&gt;&lt;span style="font-style: italic;"&gt;‘If you compare the fair with the previous days then it is not fair. In previous we had to pay 25 taka per day to the owner and now we are paying 80 taka per day’&lt;br /&gt;&lt;br /&gt;&lt;/span&gt;&lt;span style="font-style: italic;"&gt;‘I see. The government set fixed charge for the taxi owners and did not set any constraint for the rickshaw owners’&lt;br /&gt;&lt;br /&gt;&lt;/span&gt;&lt;span style="font-style: italic;"&gt;‘The owners are not responsible for this. They have to buy a tire for 250 taka while they bought it for 150 taka in the past.’&lt;/span&gt; – Rickshawala’s quick reply&lt;br /&gt;&lt;br /&gt;I was astonished hearing the rickshawala saying on behalf of the rickshaw owners. I guessed that he himself is the owner and asked the rickshawala to be sure.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-style: italic;"&gt;‘Hey, stop. Are you the rickshaw owner?’&lt;br /&gt;&lt;br /&gt;&lt;/span&gt;He smiled, looked at me and said &lt;span style="font-style: italic;"&gt;‘yes sir, I have only one rickshaw’&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;Who does not like to speak for himself?&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-7708895815698503";
google_ad_width = 728;
google_ad_height = 15;
google_ad_format = "728x15_0ads_al";
google_ad_channel = "";
google_color_border = "FFFFFF";
google_color_bg = "FFFFFF";
google_color_link = "99C9FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5914500912012912214-303443213400383776?l=boyron.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://boyron.blogspot.com/feeds/303443213400383776/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5914500912012912214&amp;postID=303443213400383776' title='7 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5914500912012912214/posts/default/303443213400383776'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5914500912012912214/posts/default/303443213400383776'/><link rel='alternate' type='text/html' href='http://boyron.blogspot.com/2007/04/i-usually-travel-by-bus-while-returning.html' title='Rickshawala'/><author><name>Mahbub-E-Elahi Ron</name><uri>http://www.blogger.com/profile/03360756520916516087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='31' src='http://bp0.blogger.com/_1UJtnTLSZB8/R3YH45i512I/AAAAAAAAACc/qJ9LbVSIpso/S220/ron.jpg'/></author><thr:total>7</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5914500912012912214.post-7752417903980951323</id><published>2007-04-25T14:23:00.000+06:00</published><updated>2007-04-28T13:23:55.290+06:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SEO'/><title type='text'>SEO Tips</title><content type='html'>&lt;p&gt;&lt;strong&gt;What *NOT* to do?&lt;/strong&gt;&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Don’t submit multiple URLs&lt;/strong&gt; to Google database for the  same site. e.g. mysite.com and mysite.com/index.html are two different URLs.&lt;br /&gt;&lt;br /&gt;Don’t do &lt;strong&gt;cloaking&lt;/strong&gt;. Cloaking is a way to keep two different pages. One is  optimized for the search engine another is optimized for user.&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Doorway pages&lt;/strong&gt; are another way of cloaking. This is the trick to  fill your home pages with keywords and keeping a link for user optimized page.&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Hidden texts and hidden links&lt;/strong&gt; with same color as page  background color are often used in doorway pages and are cause to ban from  search engines.&lt;br /&gt;&lt;div id="read_rest"&gt;&lt;a onclick="document.getElementById('rest').style.display='inline'; document.getElementById('read_rest').style.display='none'"&gt;Read the rest of this article...&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;&lt;div id="rest" style="display:none"&gt;&lt;br /&gt;Don’t link bad neighborhood as &lt;strong&gt;link farms&lt;/strong&gt; that may cause to be banned.&lt;br /&gt;&lt;br /&gt;Don’t send unsolicited  commercial emails called &lt;strong&gt;spamming&lt;/strong&gt; from your site.&lt;br /&gt;&lt;br /&gt;Selling advertising in form of  links in your site is acceptable but &lt;strong&gt;selling  PR&lt;/strong&gt; which will boost another sites PR is not.&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Multiple identical pages&lt;/strong&gt; with very similar content and  interlinking them are forbidden.&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Multiple domains&lt;/strong&gt; that redirect to same site and also  creating multiple domains that contain almost same content are not allowed.&lt;br /&gt;&lt;br /&gt;Google recommends not having  more than 100 links in a page. &lt;strong&gt;Excessive  links&lt;/strong&gt; will not ban you but will cause a low PR.&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Search Engines and the Directories&lt;/strong&gt;&lt;br /&gt;&lt;br /&gt;Directories are searchable  database of web sites that are reviewed, selected and categorized by human  beings. On the other hand a search engine crawl the web by following the links  from webpage to webpage and website to website. You don’t even need to submit  your site to a search engine in order to find your site and indexing for  searching.&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Important directories&lt;/strong&gt;&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Yahoo&lt;/strong&gt; – most popular but costs $299 and paying is not  guaranteed to be included in the top 10 listings&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;ODP&lt;/strong&gt; – Open Directory Project, Suggest your site there.  Now! This causes your site to be listed in Google&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Lycos&lt;/strong&gt; – popular but again will cost $39&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Search Engine Spiders&lt;/strong&gt;&lt;br /&gt;&lt;br /&gt;Spiders crawl from web site to  web site by following the links.&lt;br /&gt;&lt;br /&gt;Googlebot – 216.xxx.xxx.xxx,  monthly deep crawl in the database&lt;br /&gt;&lt;br /&gt;Freshbot – 64.xxx.xxx.xxx  shallow crawl&lt;br /&gt;&lt;br /&gt;Search in Google for your site  url, then click on cache for viewing the last cached view of your site by  Google&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Search Engine Friendly Site: How to&lt;/strong&gt;&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Meta&lt;/strong&gt;&lt;strong&gt; tags – &lt;/strong&gt;&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Title&lt;/strong&gt; – Choose a meaningful title that reflects your  business and cover 2 or 3 keywords. E.g.: ABC Software, the best software  development company in Bangladesh.&lt;br /&gt;&lt;br /&gt;It contains 3 important  keywords regarding your company, best, software and Bangladesh.&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Description&lt;/strong&gt; – Another important Meta  tag. It should not contain just a list of keywords but a logical sentence that  will contain your keywords. E.g.: ABC Software, a world class software  development company, special in desktop based applications.&lt;br /&gt;&lt;br /&gt;It contains your keywords and  reads like a coherent sentence also.&lt;br /&gt;&lt;br /&gt;Links at home page – try to  keep all pages link in the home page and also keep a &lt;strong&gt;sitemap&lt;/strong&gt; and link it to home page. So that spiders can follow your  whole site with maximum of following 2 links.&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Header Tags and ALT Tags&lt;/strong&gt; –&lt;br /&gt;&lt;br /&gt;Near the top of your page you  should keep your important keywords in a &lt;strong&gt;&amp;lt;H1&amp;gt;&lt;/strong&gt; tag. Google gives extra weight to text located at header tags to calculate PR.  Also use a couple of &amp;lt;H2&amp;gt; tags. E.g.:&lt;br /&gt;&lt;br /&gt;&amp;lt;H1&amp;gt;ABC Software: No 1  Software Development Company in Bangladesh  &amp;lt;/H1&amp;gt;&lt;br /&gt;&lt;br /&gt;&amp;lt;H2&amp;gt;we provide 24/7 support  to our customers&amp;lt;/H2&amp;gt;&lt;br /&gt;&lt;br /&gt;Photos will not help your  ranking but you can use &amp;lt;ALT&amp;gt; tags to describe the photo and keep 1 or 2  keywords there. Be sure that &amp;lt;ALT&amp;gt; tag is describing your photo. E.g.:&lt;br /&gt;&lt;br /&gt;&amp;lt;img src=”wo.jpg” ALT=”Web  Office: Web based office management system, one of our best software”&amp;gt;&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Add shorter pages to your site&lt;/strong&gt;&lt;strong&gt; &lt;/strong&gt;&lt;br /&gt;&lt;br /&gt;Always try to add new pages to  your site. Each a day, If you cannot add each a day then add whenever you can,  but don’t add junk&lt;br /&gt;&lt;br /&gt;Make shorter pages&lt;br /&gt;&lt;br /&gt;If you have longer pages break  them and make them shorter&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Better Search Engine Rankings for existing  site&lt;/strong&gt;&lt;br /&gt;&lt;/p&gt;&lt;ol&gt;&lt;li&gt;Remove all bad techniques as described earlier&lt;/li&gt;&lt;br /&gt;&lt;li&gt;Change your title and description to a keyword rich  format&lt;/li&gt;&lt;br /&gt;&lt;li&gt;Add lots of unique keyword rich contents to your  pages&lt;/li&gt;&lt;br /&gt;&lt;li&gt;Reciprocal Linking: Get a few websites (at least 3  or 4) to link to your site. But be very careful about the bad neighbors as  discussed earlier.&lt;br /&gt;&lt;/li&gt;&lt;/ol&gt;&lt;strong&gt;Google Page Rank (PR)&lt;/strong&gt;&lt;br /&gt;&lt;p&gt;  A web page’s Page Rank is a  number from 1 to 10 as calculated by Google for that page. The PR value is  basically what Google deems to be the importance of your page when compared to  other web pages in your category.&lt;br /&gt;&lt;br /&gt;The higher PR you rank the  better for your site to be top listed. For competitive category sites 5 is a  good PR.&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Maximize your web pages’ PR: How to&lt;/strong&gt;&lt;br /&gt;&lt;/p&gt;&lt;ol&gt;&lt;li&gt;Your pages should contain unique original contents  that are not replicated in another site and not just like affiliated links&lt;/li&gt;&lt;br /&gt;&lt;li&gt;Keyword density: you should have your main keywords  as much as possible in your page title and description as well as scattered  throughout the text of your page while still make sure that the pages are  readable, interesting and have the ability to sell&lt;/li&gt;&lt;br /&gt;&lt;li&gt;No of Visitors will increase your page PR  &lt;/li&gt;&lt;br /&gt;&lt;li&gt;Incoming Links to your page from other web pages:  most important&lt;/li&gt;&lt;br /&gt;&lt;li&gt;Header tags and ALT tags as described earlier&lt;br /&gt;&lt;/li&gt;&lt;/ol&gt;&lt;p&gt;&lt;strong&gt;Links and their efforts on Page Rank&lt;/strong&gt;&lt;strong&gt; &lt;/strong&gt;&lt;br /&gt;&lt;br /&gt;Tomorrow  &lt;/p&gt;&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-7708895815698503";
google_ad_width = 728;
google_ad_height = 15;
google_ad_format = "728x15_0ads_al";
google_ad_channel = "";
google_color_border = "FFFFFF";
google_color_bg = "FFFFFF";
google_color_link = "99C9FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5914500912012912214-7752417903980951323?l=boyron.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://boyron.blogspot.com/feeds/7752417903980951323/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5914500912012912214&amp;postID=7752417903980951323' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5914500912012912214/posts/default/7752417903980951323'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5914500912012912214/posts/default/7752417903980951323'/><link rel='alternate' type='text/html' href='http://boyron.blogspot.com/2007/04/seo-tips.html' title='SEO Tips'/><author><name>Mahbub-E-Elahi Ron</name><uri>http://www.blogger.com/profile/03360756520916516087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='31' src='http://bp0.blogger.com/_1UJtnTLSZB8/R3YH45i512I/AAAAAAAAACc/qJ9LbVSIpso/S220/ron.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5914500912012912214.post-5340163028635364259</id><published>2007-04-25T12:28:00.000+06:00</published><updated>2007-04-28T13:28:18.938+06:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='MySQL'/><category scheme='http://www.blogger.com/atom/ns#' term='aggregate function'/><category scheme='http://www.blogger.com/atom/ns#' term='group_concat()'/><title type='text'>How to use MySQL Aggregate Function GROUP_CONCAT()</title><content type='html'>Few days ago, I got a mail from one of my friend. The mail was asking a question like below:-&lt;br /&gt;&lt;p face="verdana"&gt;Answer the following question within 10 sec and without the help of a calculator.&lt;/p&gt;If 1 = 5, 2 = 25, 3 = 625, 4 = 390625, then 5 = ?&lt;br /&gt;&lt;p face="verdana"&gt;&lt;a style="cursor: pointer;" onclick="javascript:document.getElementById('ans').style.display='inline'"&gt;Answer is hidden here&lt;/a&gt;&lt;/p&gt;&lt;div id="ans" style="display: none;"&gt;Do you think the answer is (390625)²? No. The answer is 1. Notice the first statement 1 = 5.&lt;br /&gt;&lt;/div&gt;&lt;br /&gt;I asked this question to some other friends. They also replied the wrong  answer. The answer is very simple. But sometimes we make complex and  wrong solutions of simple problems. This happens due to lack of proper  understanding the 'system'.&lt;br /&gt;&lt;p face="verdana"&gt;Here is similar problem, which occurs frequently in our day to day programming.&lt;/p&gt;&lt;p face="verdana"&gt;Let you have team_member table data like below:-&lt;/p&gt;&lt;div id="read_rest_gc"&gt;&lt;a onclick="document.getElementById('rest_gc').style.display='inline'; document.getElementById('read_rest_gc').style.display='none'"&gt;Read the rest of this article...&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;&lt;div id="rest_gc" style="display:none"&gt;&lt;table face="verdana" border="1" cellpadding="5" cellspacing="0"&gt; &lt;tbody&gt;&lt;tr&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;id&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;team_id&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;fname&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;initials&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;last&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;/tr&gt;  &lt;tr&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;1&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;1&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;John&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt; &lt;/code&gt;&lt;br /&gt;&lt;/td&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;Smith&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;/tr&gt; &lt;tr&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;2&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;1&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;Irin&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;E&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;Adler&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;/tr&gt; &lt;tr&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;3&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;1&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;Michael&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt; &lt;/code&gt;&lt;br /&gt;&lt;/td&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;Angelo&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;/tr&gt; &lt;tr&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;4&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;2&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;Alan&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt; &lt;/code&gt;&lt;br /&gt;&lt;/td&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;Border&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;/tr&gt; &lt;tr&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;5&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;2&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;W&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;J&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;Akram&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;/tr&gt;&lt;/tbody&gt;&lt;/table&gt;&lt;br /&gt;Now you want a report, which will show each team members in a row.&lt;br /&gt;&lt;br /&gt;The  simple and optimal solution is to use MySQL GROUP_CONCAT() function.  MySQL GROUP_CONCAT() aggregate function is a small handy tool to solve  this type of problem. This will simplify big efforts to a small piece  of work. To see the above output using the power of MySQL  GROUP_CONCAT() aggregate function, use the following query:-&lt;br /&gt;&lt;br /&gt;&lt;code&gt;mysql &gt; SELECT  team_id AS Team, GROUP_CONCAT( CONCAT( last, ', ',    fname, ' ', IFNULL('',initials))  ORDER BY last ASC SEPARATOR '; ' ) AS Members FROM  team_member GROUP BY team_id ORDER BY team_id ASC;&lt;br /&gt;&lt;br /&gt;&lt;/code&gt;The output will be like below:-&lt;br /&gt;&lt;table face="verdana" border="1" cellpadding="5" cellspacing="0"&gt;&lt;br /&gt;&lt;tbody&gt; &lt;tr&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;Team&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;Members&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;/tr&gt; &lt;tr&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;1&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;Adler, Irin E; Angelo Michael; Smith, John&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;/tr&gt; &lt;tr&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;2&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;td&gt;&lt;code&gt;Border, Alan; Akram, W J&lt;/code&gt;&lt;/td&gt;&lt;br /&gt;&lt;/tr&gt;&lt;/tbody&gt;&lt;br /&gt;&lt;/table&gt;MySQL GROUP_CONCAT() aggregate function is available from version 4.1.&lt;br /&gt;&lt;p face="verdana"&gt;To learn more, have a look at MySQL reference manual. &lt;a href="http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html"&gt;http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html&lt;/a&gt;&lt;/p&gt;You also must know about the MySQL global variable group_concat_max_len. There was a bug regarding this variable which was fixed in a later version 5.0.19. &lt;a href="http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html"&gt;More …&lt;/a&gt;&lt;br /&gt;&lt;p face="verdana"&gt;I hope to continue finding the simple and optimal way of problem solving. &lt;/p&gt;Cheers&lt;br /&gt;&lt;br /&gt;Ron&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-7708895815698503";
google_ad_width = 728;
google_ad_height = 15;
google_ad_format = "728x15_0ads_al";
google_ad_channel = "";
google_color_border = "FFFFFF";
google_color_bg = "FFFFFF";
google_color_link = "99C9FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5914500912012912214-5340163028635364259?l=boyron.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://boyron.blogspot.com/feeds/5340163028635364259/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5914500912012912214&amp;postID=5340163028635364259' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5914500912012912214/posts/default/5340163028635364259'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5914500912012912214/posts/default/5340163028635364259'/><link rel='alternate' type='text/html' href='http://boyron.blogspot.com/2007/04/few-days-ago-i-got-mail-from-one-of-my.html' title='How to use MySQL Aggregate Function GROUP_CONCAT()'/><author><name>Mahbub-E-Elahi Ron</name><uri>http://www.blogger.com/profile/03360756520916516087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='31' src='http://bp0.blogger.com/_1UJtnTLSZB8/R3YH45i512I/AAAAAAAAACc/qJ9LbVSIpso/S220/ron.jpg'/></author><thr:total>1</thr:total></entry></feed>
