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

 
 
 

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