MYSQL : Ordering by Numbers

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/

Read More

 

Flash/SwfObject, Z-Index & Windows

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.

Read More

 

IE6 is finally near its end

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/

Read More

 

Pat Forde Says it Right

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

Read More

 

Boarding Passes

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/

Read More

 

Back in Action

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.

Read More

 
 
 
 

About Us

Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Testimonials

Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt

Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore

Join the Newsletter!

Quick Contact