Site Cloner PHP Script
Bargain Hunter PHP Script
Job Hunter PHP Script
Site Login and Access Control PHP Script

PHP LEFT (Outer) Joins

Inner joins will select data and return all entries which match

To use a left join or outer join,
1) SELECT * FROM table1 LEFT JOIN table2 ON table2.id=table1.id;

With LEFT JOIN, the first table of the statement is critical. If the first table in the statement has 5 entries, 6 entries would have been selected. But, if tbe first table selected had 6 categories it would show all six entries.