Form Email Plugin - Mysql Query - Email To (Eval)

[nbradshaw]

Hello -

I currently have this working perfectly:
-------------
$platform = $formModel->getElementData('sdm_incident_notification___platform', true);
$platform = is_array($platform) ? $platform[0] : $platform;
$customers = $formModel->getElementData('sdm_incident_notification___customer', true);
$customers = is_array($customers) ? $customers[0] : $customers;
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('internal_addresses')->from('customers')->where('customers = ' . $db->quote($customers));
$db->setQuery($query);
//echo $query;exit;
return $db->loadResult();
---------------

However - when I try to do a where "and", it does not kick off an email...the query works fine in phpmyadmin...I think I have the syntax wrong (as I am not used to using the "->" within my queries (what is this for?)

Here is the code that is not working (using "AND":

$platform = $formModel->getElementData('sdm_incident_notification___platform', true);
$platform = is_array($platform) ? $platform[0] : $platform;
$customers = $formModel->getElementData('sdm_incident_notification___customer', true);
$customers = is_array($customers) ? $customers[0] : $customers;
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('internal_addresses')->from('customers')->where('customers = ' . $db->quote($customers)->AND('platform = ' . $db->quote($platform));
$db->setQuery($query);
//echo $query;exit;
return $db->loadResult();

 

[troester]

Try
$query->select('internal_addresses')->from('customers')->where('customers = ' . $db->quote($customers).' AND platform = ' . $db->quote($platform));

 

[nbradshaw]

works great, thanks troester!

 

[rob]

alternatively this would work:

$query->select('internal_addresses')->from('customers')
->where('customers = ' . $db->quote($customers))
->where('platform = ' . $db->quote($platform));

where() can take 2 parameters.
1 - the where statement
2 - the "glue" which is either AND or OR. If not supplied the default is "AND"