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();
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();