Method: db::left_join

Runs a LEFT JOIN

Info

Syntax

db::left_join($table_1, $table_2, $on, $select, $where=null, $order=null, $page=null, $limit=null)

Parameters

• $table_1 (string) The table name of the first table
• $table_2 (string) The table name of the second table
• $on (string) The MySQL ON clause without the ON keyword. ie: "user_id = comment_user"
• $select (mixed) Either an array of fields or a MySQL string of fields
• $where (mixed) Either a key/value array as AND connected where clause or a simple MySQL where clause string
• $order (string) Order clause without the order keyword. ie: "added desc"
• $page (int) a page number
• $limit (int) a number for rows to return

Return (mixed)