version 4.4

[UsaMusa]

Yes sorry that was a syntax error.

I was trying for get this query to work:

Code:

$maxVal= $db->query("SELECT MAX(stnr) FROM standards")->first()->stnr;

but it worked just fine when when I used AS

Code:

$maxVal= $db->query("SELECT MAX(stnr) AS maxVal FROM standards")->first()->maxVal;

Thanks