How to join three MySQL database tables together in a simple SELECT statement

Following on from my post of how to join two MySQL tables together, adding a third table is just as easy, but if you need an example this one extends the previous post by adding a third table. For example I have a table of products, table of product categories and table of product suppliers, […]

Still using the old MySQL driver? What you need to know about MySQLi…

Its time to upgrade from the PHP MySQL extension The PHP MySQL extension was deprecated in PHP 5.5.0! You should upgrade your code to use MySQLi at least, even better would be upgrading to PDO. This post about selecting data uses PDO and has the full source code available for you. But back to MySQLi […]

How to join two MySQL database tables together in a simple SELECT statement

How to join two MySQL database tables together in a simple SELECT statement? For example I have a table of products and a table of product categories, how to return the category description of each product? Products ———– id category_id product_name Categories ————- id description A. In it’s simplest form you would join two tables […]