SQL – How to concatenate/combine column values into comma separated text string
The following SQL statement shows how to combine a column into a single text string - separated by a comma. For example: Name Fred Jim Jane Betty Would be combined…
Database
SQL – How to remove spaces before and after database values
The following SQL can be used to remove leading and trailing spaces from a columns values. Ideally the system that is feeding the data into the database should be doing…
Gravity Forms – How to apply default settings for new forms
The following PHP code shows how to apply default settings to new forms in Gravity Forms. To use this code you will need to have an understanding of implementing PHP…
Crystal Reports – Display running total as 0 when null value
The following steps show how to display a NULL value (a blank value) as a 0. This can be helpful when you need to use the value to perform calculations…
Crystal Reports – How to convert string date to real date value
Sometimes you may come across dates that are strings in your data source, for example a date may be '01/01/2012' in the data source instead of the standard database date…
WordPress – How to serve static content from a cookieless domain
If you're serious about optimising a WordPress website for speed, then you need to setup your website to serve the static content, such as images and css files, from a…
SQL – Quick and easy way to performance test SQL statements
There are many commercial tools to help you design and test SQL statements, as well as the execution tests in built into SQL Management Studio - however sometimes you just…
How to import large SQL export files into phpMyAdmin mySQL databases
If you've got a large SQL export file that you need to import into another mySQL database using phpMyAdmin you may hit the upload limit. Many hosts will hard set…
WordPress – What is the least database user privileges required?
The following database privileges are the least required to allow WordPress to operate completely and reliably. These permissions can be used to run a standard WordPress installation as well as…