Joomla WHERE clause with OR

A quick article on how to use the where clause in a joomla database query.

In response to a member, I use the old form where I can include the whole SQL statement:
$db->query('SELECT * FROM #__myTable WHERE condition1=true or condition2=true')
  1.  $db->query('SELECT * FROM #__myTable WHERE condition1=true or condition2=true') 

Method #1 - chain:
    ->where($db->quoteName('condition1') . ' = '. $db->quote('true'),'OR')
    ->where($db->quoteName('condition2') . ' = '. $db->quote('true'))
  1.  $query 
  2.      ->where($db->quoteName('condition1') . ' = '$db->quote('true'),'OR') 
  3.      ->where($db->quoteName('condition2') . ' = '$db->quote('true')) 

Method #2 - array:
$conditions = array(
    $db->quoteName('condition1') . ' = true', 
    $db->quoteName('condition2') . ' = true'
$query->where($conditions, 'OR')
  1.  $conditions = array( 
  2.      $db->quoteName('condition1') . ' = true', 
  3.      $db->quoteName('condition2') . ' = true' 
  4.  )
  5.  $query->where($conditions, 'OR') 
Category: Joomla :: Article: 569

Credit where Credit is Due:

Feel free to copy, redistribute and share this information. All that we ask is that you attribute credit and possibly even a link back to this website as it really helps in our search engine rankings.

Disclaimer: Please note that the information provided on this website is intended for informational purposes only and does not represent a warranty. The opinions expressed are those of the author only. We recommend testing any solutions in a development environment before implementing them in production. The articles are based on our good faith efforts and were current at the time of writing, reflecting our practical experience in a commercial setting.

Thank you for visiting and, as always, we hope this website was of some use to you!

Kind Regards,

Joel Lipman

Related Articles

Joes Revolver Map


Badge - Certified Zoho Creator Associate
Badge - Certified Zoho Creator Associate

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Donate to Joel Lipman via PayPal

Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF
© 2024 Joel Lipman .com. All Rights Reserved.