While you already use many functions in WordPress to communicate with the database, there is an easy and safe way to do this directly, using the $wpdb class. Built on the great ezSQL class by Justin Vincent, $wpdb enables you to address queries to any table in your database, and it also helps you handle the returned data.
Because this functionality is built into WordPress, there is no need to open a separate database connection (in which case, you would be duplicating code), and there is no need to perform hacks such as modifying a result set after it has been queried.
View original article:
How To Interact With The WordPress Database
Two weeks ago we published the first part of Photoshop tips and tricks for photo retouching. Today, we’ll be presenting the rest of the article. We hope that these techniques will be quite useful for your workflow. You may know some of them, but hopefully not all of them. We have had articles on various tools in Adobe Photoshop but this one is focused more on the techniques rather than the tools provided.
View this article:
Photo Retouching Tips And Tricks In Photoshop
Office applications are getting very advanced these days offering all sorts of fancy features for data visualization. Graph generation is a standard feature in desktop applications like Microsoft Excel or OpenOffice.org Calc, but it can also be achieved in non-spreadsheet applications like Adobe Illustrator. [Links checked & repaired March/06/2017]
If you’re unfamiliar with the process of creating graphs in Illustrator, this article will help in giving you some insight into the work-flow.
How To Create Graphs In Illustrator