Reorder Columns in a Tablehttps://www.joellipman.com/articles/else/database/reorder-columns-in-a-table.html

22 July 2013 on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this. How? Taken from the best forum for programming Qs&As: http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns Method: phpMyAdmin So in the...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: *

Split a row into multiple rows based on a column valuehttps://www.joellipman.com/articles/else/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

23 August 2013 003 1.00 1999-02-26 -- note the dates increment and do not account for days off (eg. Saturday / Sunday) How? Adapted from a forum topic: SQLTeam Forums First of all, we want the rows to multiply based on the value of the column: SELECT EmployeeNo ,...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

UTF8 Unicode PHP MySQL for International Charactershttps://www.joellipman.com/articles/cms/website-development/php/utf8-unicode-php-mysql-for-international-characters.html

22 October 2010 my extension read data from a MySQL database and display the caracters as intended with UTF8. I tried enough extensions and forum solutions, and although these changes would have an effect on the module (such as take away accents and convert to ASCII),...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

AutoHotkey Ternary Operatorhttps://www.joellipman.com/component/content/article/autohotkey-ternary-operator.html?catid=48&Itemid=165

27 April 2010 add as there are a whole bunch of methods using the Ternary Operator in AutoHotkey (discussed on http://www.autohotkey.com/forum/topic29752.html) which I'll put in soon. I just needed something on my site now as I find myself looking for this bit of...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

Add a template to the dropdown in Kunenahttps://www.joellipman.com/articles/cms/joomla/add-a-template-to-the-dropdown-in-kunena.html

20 September 2009 folder inside Rename this to the name of your new template (avoid any spaces) Download the new template for the Kunena forum This is what the official Kunena documentation says: Installing another Template Download the Template package. Open your FTP...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Hide Menu Item from Registered and Special https://www.joellipman.com/articles/cms/joomla/hide-menu-item-from-registered-and-special.html

06 September 2009 to this link if you want to clean out a front-end admin interface with your website's style. The following is from http://forum.joomla.org/viewtopic.php?f=32&t=252258&start=0 at this date/time. Can't simply hide an item but can hide a menu (of course...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Two icons created on Androidhttps://www.joellipman.com/articles/else/app-dev/android-os/two-icons-created-on-android.html

20 October 2014 app and it creates two icons: Why? I don't think I'll forget this one but I was stumped for a bit until I found it on the a forum: Stack Overflow: Android App Development. How? Basically don't have the following declared more than once in the...

• Type: Article
• Author: Joel Lipman
• Category: AndroidOS
• Language: *

Select unique values in Microsoft Excel columnhttps://www.joellipman.com/component/content/article/select-distinct-values-in-microsoft-excel-column.html?catid=110&Itemid=165

03 July 2012 I'd put a quick note here, I tried a fair few solutions that didn't work and then found this hidden away in a forum: Quick Count =INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&""))) This returns the number of unique values in the range A3 to...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB