Conditional Stacked Functions in selecting #174
Description
I see in the readme file it references that you can use a join in a selecting statement, but I can't seem to get it to work. Could someone please show me some examples on how this works? This is what I've tried so far
$results = $this->conn->selecting("me_supplier", "me_supplier.supplier_id, me_supplier.supplier_contact_id, me_contact.contact_name, me_contact.contact_email, me_contact.contact_phone, me_contact.contact_status, me_supplier.supplier_account_code, me_supplier.supplier_website", leftJoin("me_contact", "me_supplier", "contact_id", "supplier_contact_id"));So far this tells me that there are no results, but there definitely are as the following works
$results = $this->conn->selecting("me_supplier", "me_supplier.supplier_id, me_supplier.supplier_contact_id, me_supplier.supplier_account_code, me_supplier.supplier_website");I'm also wanting to be able to add where statements in there dynamically based on what a user puts in the URL.