Where clause

[Hall of Famer]

Its quite easy, do this:

PHP Code:

$stmt = $adopts->join("adoptables_conditions", "adoptables_conditions.id = adoptables.id")                    ->select("adoptables", array(), "whenisavail = 'shop'"); 


The select() method accepts three arguments: table, columns and whereclause. The table is quite obvious, while columns need to be an array of what columns you want to fetch(pass an empty array to fetch all columns). The whereclause is whatever is after the WHERE keyword in an sql statement.