SQL Cheat Sheet

This is a handy cheat sheet for simple SQL reporting. Ordering Columns Ordering by a single column criteria: SELECT * FROM <table name> ORDER BY <column> [ASC|DESC]; ASC is used to order results in ascending order. DESC is used to order results in descending order. Examples: SELECT * FROM books ORDER BY title ASC;SELECT * … Read more

Learning Progress Part II

The Progress So it’s been almost two and a half months since I started learning how to code. During that time I’ve finished the Beginning PHP and Development for WordPress tracks on Team Treehouse. Before starting another track I wanted to make sure I had integrated what I learned. So I made projects for myself … Read more

WordPress $wpdb Object Overview

This is a really helpful overview from BenBaltar on how to run a query on the $wpdb. I personally used this when I created a function within a plugin to check if a post was a child of an array of posts. One question I have is if it is the most efficient use of … Read more

Better WordPress Email Management with MailGun

I’ve always had a lot of trouble with the WordPress email system. Whether it’s dropping emails, not receiving emails, emails ending in spam, not authenticating with Gmail, DNS records being incorrect, a lot can and has gone wrong. Most guides out there give you a generic SMTP plugin to install and say that should solve it. Sometimes … Read more

Update WordPress links with SQL

It’s not easy changing your WordPress site links. You might have to change http to https or correct a spelling error. If changing settings or using plugins don’t help, here’s how to change it manually with SQL. Most of us will have to use phpmyadmin. Find your database manager.  In your database command line execute the … Read more

Hello, World!

This is my first blog post. I’m going to write down my experience as I learn web development so that I can look back and see the progress (or regress) I’ve made and if I find success as a developer, to show others that it’s possible for them too. Some Background I never intended to … Read more