Monthly Archives: January 2016

Solved – Chronoforms V5 won’t add database entry because of duplicate id – 1062 – Duplicate entry ’28’ for key ‘PRIMARY’

I had to hard code a URL and pass some parameters to a Chronoform in an article. The form submitted to a database. The form submission was taking the article ID as the form’s unique ID, so I could only … Continue reading

Posted in Chronoforms, Joomla, PHP, Programming | Leave a comment

using Join with Joomla 3 select statement

I took a while to get this right. $db = JFactory::getDbo(); $query = $db->getQuery(true); $query ->select(array(‘a.id’, ‘a.name’, ‘b.user_id’, ‘b.body’)) ->from($db->quoteName(‘#__users’, ‘a’)) ->join(‘INNER’, $db->quoteName(‘#__user_notes’, ‘b’) . ‘ ON (‘ . $db->quoteName(‘a.id’) . ‘ = ‘ . $db->quoteName(‘b.user_id’) . ‘)’) ->where($db->quoteName(‘b.body’) . … Continue reading

Posted in Joomla, PHP, Programming | Leave a comment

How to use CSS Flexbox

Flex is not fully supported by all browsers, but it very helpful for centering items with CSS. If you are not fimiluar with Flex below is a YouTube video I found very helpful. I hope this helps someone else out … Continue reading

Posted in browser, CSS, Responsive Web Design | Leave a comment

Joomla 3 – sample query of the database

Here is a snippet of code I often need to build a database query in Joomla.   <?php <?php $db = JFactory::getDbo();   $query = $db->getQuery(true); // Individual fields //$query->select($db->quoteName(array(‘firstname’, ‘lastname’)));  // or all fields $query->select(‘*’) ; $query->from($db->quoteName(‘#__free_month’)); $db->setQuery($query);   $results … Continue reading

Posted in Joomla, PHP | Leave a comment

Centering a div between a div floating left and a div floating right – Responsively

Here is what I ended up using for the CSS <style> #contain { width: 100%; padding: 0; margin: 0; display: table; } #left, #right { text-decoration: none; display: table-cell; width: 310px; text-align: center; background: #FF9000; color: #FFFFFF; padding: 2% 0; … Continue reading

Posted in browser, CSS, Joomla | Leave a comment

CSS transitions – Background Color

Here is an example using a class .someclass { -webkit-transition: background-color 2s; -moz-transition: background-color 2s; -o-transition: background-color 2s; transition: background-color 2s; } .someclass:hover { background-color: #new color; } This page helped me get it working. transition Here is a link … Continue reading

Posted in Uncategorized | Leave a comment

Make a div / div tag a hyperlink or link

This tip is very helpful with today’s web where a lot of the graphic stuff such as drop shadows and gradients are being done through CSS. <div onclick=”location.href=’newurl.html’;”>&nbsp;</div> New Window: <div onclick=”window.open(‘newurl.html’,’mywindow’);” style=”cursor: pointer;”>&nbsp;</div>   I hope this helps someone … Continue reading

Posted in Uncategorized | Leave a comment

Filter Google Analytics by Geo Location such as United States Only

We run Analytics for companies that only operate in the US, so when I see 51 hits from Russia it is worthless to my customers. The answer is to filter their results so we can really understand their web traffic. … Continue reading

Posted in Analytics | Leave a comment

Photoshop Tutorial on Dispersion / Sand Storm Effect

Photoshop is amazing. Combined with YouTube you have a visual learning experience.  

Posted in Photography, Photoshop | Leave a comment

Creating a star burst twirl effect in photoshop

I need to do this for an ad we were making. I used the following tutorial on YouTube to get what I was looking for. I hope this helps someone else out there…  

Posted in Photoshop | Leave a comment