Wrong comment count in WordPress
Should you for some reason end up with what appears to be wrong number of comments listed next to your posts (like me). The following little php script may come …
Wrong comment count in WordPress Read MoreProgramming
How to find and replace text in a MySQL Database using SQL
Lets say you have a word or reference you need to change within one (or several) column(s) in one of your tables. The following SQL statement will then come in …
How to find and replace text in a MySQL Database using SQL Read More
Easily convert Excel to MySQL
Found this tool while I was trying to save time grabbing content from an old MS Access database. Exporting the data to Excel and then using the tool below saved …
Easily convert Excel to MySQL Read More
How to Disable Automatic Updates in WordPress
Since 3.7, a typical WordPress install will now be able to automatically update itself when there is a new minor/security release available without any user input. For example, it will …
How to Disable Automatic Updates in WordPress Read More
Finding duplicate entries in MySQL
From time to time I need to check for duplicate entries in my databases. E.g. when I have large numbers of clients signing up for events or similar. I know …
Finding duplicate entries in MySQL Read MoreWorking with linked tables
I’m currently working on a website project that requires separate websites (different language dependant domains) to share a common image database. Thus, to avoid having to upload and link in …
Working with linked tables Read MoreUsing PHP to print only the first sentence
Ever wanted to pull just the first sentence of a text and print it? If yes, this is for you. Simply add the following code (in PHP) to your page/system …
Using PHP to print only the first sentence Read MoreHow to remove the active/focus borders
I’m sure you have noticed that when you click a hyper link, and especially a linked image, a dotted border appears around it. Have a look at CSSplay for more …
How to remove the active/focus borders Read MoreIntroducing SWFObject v2
SWFObject is an easy-to-use and standards-friendly method to embed Flash content, which utilizes one small JavaScript file. I’ve previously mentioned SWFObject in one of my posts last year. The latest …
Introducing SWFObject v2 Read MoreAnother browser detection method
First let me emphasise that I’m not a big fan of making up different styling rules for the various browsers. But in some (most) cases it’s an absolute necessity. Before …
Another browser detection method Read More