I Are Nick

MYSQL : Ordering by Numbers

Nick Searle — Fri, 23 Apr 2010 02:12:16 +0000

I came across this post today in search of being able to order a varcahr field by the true number value. When running a normal “ORDER BY column_name”, your data will be returned to you in an order of the 0 to 9 based off the first character. I found a quick and simple solution – wrap your column_name with the absolute value, ABS(), function.

Quick Example

$query = “SELECT * FROM table_name ORDER BY ABS(retail_price) DESC “;

In this example, I selected all of the data from my table and ordered it by the retail_price column, descending from 9-0.

And here is the link for an in depth walk-through of this - http://www.lost-in-code.com/programming/mysql/mysql-order-by-numbers/

Flash/SwfObject, Z-Index & Windows

Nick Searle — Wed, 14 Apr 2010 17:57:30 +0000

So, @cointilt and I debugged an issue that we ran into while developing a website. For some odd reason when we embedded the flash element using swfobject all of our divs that should have been floating above the flash holder, were not. The interesting thing is that it was only happening on all Windows browsers and no Mac browsers. Hmmmm….after searching a little bit, I came across this post in Stackoverlow which simply said to set your wmode to transparent. So, low and behold, if you are trying to run a z-index on flash objects and div elements, set your wmode parameter to transparent.

IE6 is finally near its end

Nick Searle — Tue, 02 Feb 2010 23:59:54 +0000

Google finally made the right decision in dropping support for IE6, beginning March 1, 2010. We need the big dogs to make the moves for us web developers, and this is what they are doing. IE6 has caused many problems and stress for the entire online development world. Let’s get rid of this horrible Microsoft product!

http://www.digitaltrends.com/computing/google-to-stop-supporting-internet-explorer-6/

Pat Forde Says it Right

Nick Searle — Sat, 09 Jan 2010 20:55:54 +0000

This recent Pat Forde posting on ESPN.com has been flooding like wild fire through tweets and posts the last few days. To say the least, BSU deserves a fair shot at being ranked #1 in the 2010 pre-season rankings. But, in my honest opinion, returning 21 of it’s 22 starters from last year’s team and grabbing it’s second Fiesta Bowl victory won’t be enough for BSU to earn a spot in the top 3 ranks. But thanks for a great article and believing in us Pat.

http://sports.espn.go.com/espn/columns/story?columnist=forde_pat&id=4807492&sportCat=ncf

Boarding Passes

Nick Searle — Thu, 07 Jan 2010 02:39:48 +0000

I came across an interesting article today that discussed why airport boarding passes are horribly designed. Loved the design ideas I came across and the links that were posted. Enjoy!

http://passfail.squarespace.com/

Back in Action

Nick Searle — Wed, 23 Dec 2009 02:17:54 +0000

So, I’ve come to agreement with my inner self that it’s time to start blogging/writing/expressing my thoughts on a steady basis. It’s about damn time, huh? Well, keep tuned for some of my ramblings on sports, technology, music, advertising, and marketing.