[RESOLVED] Function Problem/Question

[mhodge87]

Here is my function:

function timePerMonth($query, $ecid, $pos)
{
 include "../connection.php";

 $sql = sprintf("SELECT `TOTAL` FROM jos_onlinetime_$pos WHERE CID='%s' && `MONTH`='$query'",
        mysql_real_escape_string($ecid, $con));
 $query = mysql_query($sql, $con) or die("There was an error with the query: $sql" . mysql_error());
 $total = "0";
 if(mysql_num_rows($query) != "0")
 {
    while ($mtotal = mysql_fetch_assoc($query))
    {
       $total = $total + $mtotal['TOTAL'];
    }

$dtotal =  timeCalc($total, "Y");
 }

  if(mysql_num_rows($query) == "0")
  {
    $dtotal = "00:00";
  }

 return $dtotal;

}

Here is the TimeCalc Function:

function timeCalc($seconds, $month)
{

   $hour = floor($seconds / 3600);
   $min = floor(($seconds % 3600) / 60);

   if($month == "Y")
   {
      $time = $hour . ":" . $min;
   }else{

  $time = $hour . " hours and " . $min . " minutes";
   }
   return $time;
}

Its not outputting anything. But I'm not getting an error either lol. Any ideas?

[laserlight]

How do you use the functions?

[mhodge87]

the timeCalc converts seconds to hours/minutes
The timePerMonth function references a table, pulls out all entries that match month and cid, and then adds totals from each posistions and puts it through to the time function to convert those seconds to minutes/hours. The time function works. Its the timePerMonth one that is having the issues (I only put it in to reference because it is called by the other function)

Here one example of code that calls the function:

<? timePerMonth($month_q_12, $cid, 'APP'); ?> </td>

[dagon]

well your not doing anything with the return value, echo perhaps?

[mhodge87]

lmao that was it. A simple echo. Hardly worth a post lmao. Thanks!