Im doing two queries to a database, they are functional the same, but with other values.
CODE1 :
$sql= "SELECT sum(amount) as Samount, sum(add25) as Sadd25, sum(add50) as Sadd50, sum(deplacement) as Sdeplacement FROM workhours WHERE reportID = '$reportID'";
$sumWorkhoursData=mysqli_query($link,$sql);
unset($sql);
while($sWorhoursInfo=mysqli_fetch_array($sumWorkhoursData)){
$totalWork = $sumWorkhoursInfo['Samount'];
print_r(var_dump($sWorkhoursInfo));
}
the var_dump gives NULL
If the $sql
is copied to database manually, then it gets a good result which is one row.
CODE2 :
$sql= "select sum(time) as Stime, sum(amount) as Samount FROM trip WHERE reportID = '$reportID'";
$sumTripData=mysqli_query($link,$sql);
unset($sql);
while ($sTripInfo=mysqli_fetch_array($sumTripData)){
$totalTrip = $sTripInfo['Stime'];
print_r(var_dump($sTripInfo));
}
in this case, var_dump gives array(4) { [0]=> string(2) "20" ["Stime"]=> string(2) "20" [1]=> string(3) "151" ["Samount"]=> string(3) "151" }
what is wrong here?