Joomla database functions for building a query include a useful one for adding to the where clause with with a different condition (AND | OR) to the default you are using. 

But it has a gotcha if you are building a complex query with several possible WHERE elements

Tags:
Joomla:
Php:

In improving one of my Joomla components I found myself disappearing down a rabbit hole of confusion on t'internet over colour spaces, and in particular the differences between RGB, HSV, and HSL (plus of course for old TV hands like me YUV or Y'CrCb)

Joomla 3 has some strange restriction on the height of a modal popup in a component view. 

My workaround is this:

I have a problem with the xbCulture components when it comes to uninstalling them.