The MySQL Inner join
A MySQL Join is when data is collected from two or more tables and “joined” on keys to return as one, saving you doing multiple queries. There are several types…
Tag: How to
Basic Linux commands Part 2: Storage and disk information
Part 2 in the Basic Linux commands; How to view storage space details and information such as free space on Linux, Part 1 was Navigation, folders and files. Viewing disk…
Basic Linux commands Part 1: Navigation, folders and files
No GUI just text, Starting out with terminal can be confusing and daunting. Looking past the black console commands are actually fairly simple. Here are the basics in navigation and…
PHP MySQL loop with Bootstrap 4 columns
Here is how to implement the Bootstrap grid system into a PHP MySQL foreach loop. The code is set to be 4 columns on large screens, 2 on small screens…
How to do a MySQL GROUP BY with ORDER BY on a COUNT()
MySQL Group by returns the data of the same value into a set rows. It is often use with COUNT, SUM or AVG etc. Doing this will return how often…
Zip and Unzip files in Ubuntu
Zipping is the act of compressing a folder or files into one file (.zip) which can then be unpacked to return to the many files again. This is done for…
PHP MySQL PDO select foreach loop
Doing a loop through on a MySQL query is super useful and common. It allows you to make tables, rows and output data in a controlled manner without doing many…
Updating the Sony A6000 to 3.21 on Windows 10
19th March 2019 Sony A6000 firmware version 3.21 was released My current A6000 firmware is version 3.20 Version 3.21 link here: Sony doesn’t give a whole lot of information for…
PHP format and style MySQL DateTime
MySQL DateTime format is Y-m-d H:i:s known as Year-month-day hour:minute:second. It is the bare bones datetime format for both MySQL and PHP…. it contains all you need to know and…
Adding FFmpeg to system path Windows 10
Being able to use FFmpeg.exe without referencing its location or copying it into the folder you’re operating in is a huge piece of simplicity. Once FFmpeg is added to your…