I am running into errors on this code, not sure what is missing here.
$dbcon = JFactory::getDbo();
$foodscores = $data['daily_logs_2___food_score'];
$mydata = $data['daily_logs_2___user_raw'];
$query = $dbcon->getQuery(true);
$query
->select('AVG(food_score) AS myavg_foodscore')
->from('daily_logs_2')
->where('user = '. $dbcon->quote($mydata));
$dbcon->setquery($query);
$myavg_foodscore = $dbcon->loadResult();
Can I run a second query right after the last line?
$query
->select('AVG(food_score) AS avg_foodscore')
->from('daily_logs_2')
$dbcon->setquery($query);
$avg_foodscore = $dbcon->loadResult();
Thank you for your assistance.
$dbcon = JFactory::getDbo();
$foodscores = $data['daily_logs_2___food_score'];
$mydata = $data['daily_logs_2___user_raw'];
$query = $dbcon->getQuery(true);
$query
->select('AVG(food_score) AS myavg_foodscore')
->from('daily_logs_2')
->where('user = '. $dbcon->quote($mydata));
$dbcon->setquery($query);
$myavg_foodscore = $dbcon->loadResult();
Can I run a second query right after the last line?
$query
->select('AVG(food_score) AS avg_foodscore')
->from('daily_logs_2')
$dbcon->setquery($query);
$avg_foodscore = $dbcon->loadResult();
Thank you for your assistance.