I Are Nick

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/

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.

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/

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

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/

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.