I am trying to write code for a calc element. My query is below:
Is there something wrong with the writing?
I only get as a result the records from the first element (id_therapeias).
It seems that everything after the and is ignored!!!
I cannot find any specific examples on this kind of joomla queries according to if i need this arrow before and or something else.
Can someone help?
Code:
$query->select('SUM(amount)')->from('sinedries')->where('id_therapeias = '.$id)->and('plirwmi = 2');
Is there something wrong with the writing?
I only get as a result the records from the first element (id_therapeias).
It seems that everything after the and is ignored!!!
I cannot find any specific examples on this kind of joomla queries according to if i need this arrow before and or something else.
Can someone help?