code problem

[mattia]

Hi

I wrote this code to get the hours of a pilot on a single airplane in profile_stasts.tpl but don't work

<?php
$query = 'SELECT flighttime FROM '.TABLE_PREFIX.'pireps
WHERE aircraft = 6
AND pilotid = '.Auth::$userinfo->pilotid';  --------------->I believe that the error is here
$result=DB::get_row($query);
echo $result->distance;
{
}
?>

Can you help? many thanks

Regards

[SouthwestVA]

<?php
$query = 'SELECT flighttime FROM '.TABLE_PREFIX.'pireps
WHERE aircraft = 6
AND pilotid = '.Auth::$userinfo->pilotid.';
$result=DB::get_row($query);
echo $result->distance;
{
}
?>

you for got a . i think try that.

[mattia]

what? sorry but I did not understand

[SouthwestVA]

AND pilotid = '.Auth::$userinfo->pilotid';

that part, to echo inside of a php code its '.xxx.' you for got the 2nd dot

It should be this:

AND pilotid = '.Auth::$userinfo->pilotid.';

[mattia]

dont work this error

Parse error: syntax error, unexpected T_LNUMBER in /var/www/virtual/italianivolanti.it/htdocs/iv/core/templates/profile_stats.tpl on line 27

[SouthwestVA]

<?php

$query = 'SELECT flighttime FROM '.TABLE_PREFIX.'pireps

WHERE aircraft = '6'

AND pilotid = '.Auth::$userinfo->pilotid.';

$result=DB::get_row($query);

echo $result->distance;

{

}

?>

try that

[mattia]

works many thanks

[SouthwestVA]

no problem