SQL Joins CheatSheet
This is one of the quickest SQL desk side notes for web developers and php programmers. Simple examples for all types of SQL Joins, such as Left Join, Inner Join, Full Outer Join, and Right Join variations. Download the PDF Transcribed SQL Joins SELECT <select_list> FROM TableA A LEFT JOIN TableB B ON A.Key = B.Key SELECT <select_list> FROM TableA A LEFT JOIN TableB B ON A.Key = B.Key WHERE B.Key IS NULL SELECT <select_list> FROM TableA A FULL OUTER JOIN TableB B ON A.Key = B.Key SELECT <select_list> FROM...
Top 10 reasons why your web design should be responsive (RWD)
If you have heard or read about responsive websites, but don’t believe that your site needs to be updated in this manner, you may be missing out. There are a strong number of reasons why a responsive website is vital for growing your business and the following 10 reasons are all big factors in why should be looking to switch to a responsive website like ours. This is not just a fad It can be easy to dismiss any new development with respect to websites as being a fad that...
Magento E-commerce For Fashion Retailers
Magento Ecommerce There is a growing level of interest and praise being ushered on to the Magento ecommerce platform, and if you are looking for a reliable and reputable ecommerce platform, this is certainly a platform worth examining. Industry experts are in agreement that Magento has the ability to save time, allow you to offer a more engaging service to your client and it can help your firm to save money, due to the open source nature of the platform. Being able to be more efficient and effective while spending...
10 Mac Apps/Utility tools to help with web design and development + windows
We all have our little gems that we use to save us time and minimise repetetive tasks in our day to day web design work. Below I will list some of the ones that save me time and effort and hope to start a dialogue because I have a feeling other people are sitting on links to good freeware that can help in the long run. I have skipped the obvious ones like filezilla, sublime etc. If you guys think I should list out all of them as well I...
Web designers in London
Why use web designers in London, well thanks to London itself being the number one choice city in the world to live and work in, if not THE best, the web design industry has flourished here. Our team of web designers in London who founded Active Webdezign fifteen years ago have all been able to evolve and grow with the company thanks somewhat to its location. When we opened our doors in 1999 web development especially eCommerce was quite a technical feat, so we were in the hands of old school software developers who we...
How to access Magento core inside a custom build
We have recently been working on a few Magento Ecommerce sites that either incorporate wordpress or a custom build using the Yii framework. If you, like us; have done custom builds like this you find yourself sometimes wanting to access Magento core functionality in your other pages. Using the below code you can easily access your Magento core 001002003004005006007008 <?php require_once('app/Mage.php'); // Path to Magento umask(0); Mage::app(); // Target a specific product by ID (7 in our case) $_product= Mage::getModel()->load(7); echo->getName(); Another quick example would be to access your Magento navigation inside your custom built project: 001002003004005006007008009010 <?php require_once('app/Mage.php'); // Path to Magento umask(0); Mage::app(); // Include Magento...