Posts By:

Moving a WordPress database to another domain

Posted by & filed under Wordpress.

Here are the SQL queries to update a WordPress database from one domain to another: # define var for old site SET @old_path = ‘http://oldsite.com’; # set var for new site SET @new_path = ‘http://newsite.com’; UPDATE wp_options SET option_value = replace( option_value, @old_path, @new_path ) WHERE option_name = ‘home’ OR option_name = ‘siteurl’; UPDATE wp_posts… Read more »

IE7 CSS dropdown menus

Posted by & filed under CSS.

Problem: The dropdown ULs are positioned behind the content instead of on top of it, which is also causing it to ‘disappear’ when you try to move the mouse onto it. Answer: See http://jonathanstegall.com/2009/01/15/ie-z-index-bug-with-css-dropdown-menu/

Opacity for Internet Explorer

Posted by & filed under Odds.

If you want opacity to work in IE versions < 9, the order should be: -ms-filter:"progid:DXImageTransform.Microsoft.Alpha(Opacity=0)"; // first! filter: alpha(opacity=0); // second! The first line is for IE8, the second for IE5-7. Link: http://www.quirksmode.org/css/opacity.html

SASS and LESS

Posted by & filed under Odds.

Sass and Less allow you to be more programmatic about your CSS by introducing variable, conditional operators and basic if-for-each logic (Sass only for the latter, at the moment anyway.) I had a few problems setting up Sass on my PC, but that was more to do with me rushing without reading. I’m sure no… Read more »

Bitnami