Author: Jamie

  • Drag and Drop with AJAX Example

    At my work it’s quite clear to me that a lot of people have difficulty with both AJAX and Javascript drag and drop event functionality.  In this article, I thought I would provide a realistic and simplistic example of how to accomplish both AJAX and drag and drop together.

    By the end of this article you will be able to create an extremely slick content management system that works really smoothly. (more…)

  • SQL Tips – Why LEFT JOINS are bad

    When you do SQL queries do you find yourself always, or almost always, using left joins?  If you’ve answered yes to this question, I would suggest to continue to read and understand some downfalls that you might be getting yourself into.

    Let’s start by looking at a standard query that has a left join:

    [code]
    SELECT * FROM users u LEFT JOIN countries c ON c.id = u.country_id WHERE u.id = 5
    [/code]

    The following query will return all fields from the users table and all fields from the countries table.  Now you’re thinking, “Yeah, looks good, so what’s wrong with this?”.  Well, I’m glad you asked. (more…)

  • How to get indexed by Google in ONE hour

    If you’re not familiar with how some people accomplish getting their web sites submitted to Google quickly, you are going to absolutely love this article.

    I’ve bet you’ve heard from many people that it can take days, weeks, even months to get indexed by Google.  If you have heard that, you’re now thinking, “OK Jamie, you must have had a really stressful day at work today and you’re now hallucinating that this is possible!”.

    If I read this blog title a while ago, I’m sure I would be thinking the same thing as you!  Ok, let’s move on to how to get indexed by Google within one hour. (more…)

  • YSlow – Helping slow web pages load faster

    This article is a continuation to my article about FirebugYSlow is an add-on to Firebug that helps developers determine why a site is loading slowly.

    After you install YSlow, if you open up Firebug in Mozilla a new tab will now appear called “YSlow”.  The next steps would be to load a web site that you want to check it’s performance.  After the web site has loaded, click the YSlow tab, if the results don’t compile automatically, click the Performance button to run the diagnostics.

    The grading is made up of 13 steps.  For each step you receive a grade from A to F.  An overall grade is compiled in the same format. (more…)

  • Firebug – A developer’s best friend

    I think a good place to start is to describe one of my favorite tools.  It’s called Firebug, it’s an add-on for Mozilla browsers.

    At work, if one of my co-workers comes to me in the J-Block and asks a Javascript or CSS question, before I even consider helping them I ask if they reviewed the styles or the Javascript in Firebug.  9 times out 10 if it’s a really easy answer, you’ll see it almost immediately with the help of Firebug. (more…)