Hi,
i would like to do a sqlquery, but no matter what example or other code i use i always get the same syntax error:
Parse error: syntax error, unexpected '$checkIfReceived' (T_VARIABLE), expecting function (T_FUNCTION) on line 15.
Here's the code i use:
$checkIfReceived = DB::query('SELECT Created FROM checkSituationsFormSubmissions WHERE ReceivedSecondEmail == 0');
return $checkIfReceived;
$checkIfReceived = new SQLQuery();
$checkIfReceived->setFrom('checkSituationsFormSubmissions');
$checkIfReceived->selectField('Created');
$checkIfReceived->addWhere('ReceivedSecondEmail' = 0);
$result = $checkIfReceived->execute();
return $result;
I tried to use two different syntaxes but both off them fail. Does anyone have an idea?
thanks in advance.