Display a decimal field

lyndonlegend

I have the following php code but the penmin field is defined as a decimal 3,2 and should show as 1.50 if there is one penalty. However, it just shows as 1.

Also, the last bit of php code at the very bottom I get an error for dividing by zero.
The field savepct is defined as a decimal 4,3.

The results of the code can be seen at:

http://www.reedsburgpolars.com/pwstats.php

<?php
$host="localhost";
$usrnm="XXXXXXXX";
$passwrd="XXXXXXXX";
$database="XXXXXXXX";

    $tablename="pwstats";

    $jersey=$_GET["jersey"];
    $firstname=$_GET["firstname"];
    $lastname=$_GET["lastname"];
    $date=$_GET["date"];
    $gametime=$_GET["gametime"];
    $goals=$_GET["goals"];
    $assists=$_GET["assists"];
    $penalties=$_GET["penalties"];
    $penmin=$_GET["penmin"];

    $con= mysql_connect($host,$usrnm,$passwrd)
      or die("Connection failed!!!");

    $varselect=mysql_select_db($database)
      or die("Database selection failed!!!");

    $sql = mysql_query("SELECT`jersey`, sum(goals) as tot_goal,  sum(assists) as tot_asst, 
                        sum(penalties) as tot_pen, sum(penmin) as tot_min FROM pwstats GROUP BY jersey") 
      or

die(mysql_error());

    $num = mysql_num_rows($sql);

    if (empty($num))
      die('No records found');

    echo '
      <table border="4" width="100%" cellspacing="2" cellpadding="4">

        <tr align="center">
          <td>
            <b>PLAYER</b>
          </td>
          <td>
            <b>GOALS</b>
          </td>
          <td>
            <b>ASSISTS</b> 
          </td>
          <td>
            <b>PENALTIES</b>
          </td>
          <td>
            <b>PENALTY MINUTES</b>
          </td>
        </tr>';

    while ($row = mysql_fetch_assoc($sql))
    {

    echo '
        <tr>
          <font color="#000000">
          <td align="center">',$row['jersey'],'</td>
          <td align="center">',$row['tot_goal'],'</td>

          <td align="center">',$row['tot_asst'],'</td>

          <td align="center">',$row['tot_pen'],'</td>
          <td align="center">',$row['tot_min'],'</td></font>
        </tr>';

    }

    echo '

      </table>';
  ?>

<?php
$host="localhost";
$usrnm="XXXXXXXX";
$passwrd="XXXXXXXX";
$database="XXXXXXXX";

    $tablename="pwstats";

    $jersey=$_GET["jersey"];
    $firstname=$_GET["firstname"];
    $lastname=$_GET["lastname"];
    $date=$_GET["date"];
    $gametime=$_GET["gametime"];
    $goals=$_GET["goals"];
    $assists=$_GET["assists"];
    $penalties=$_GET["penalties"];
    $penmin=$_GET["penmin"];

    $con= mysql_connect($host,$usrnm,$passwrd)
      or die("Connection failed!!!");

    $varselect=mysql_select_db($database)
      or die("Database selection failed!!!");

    $sql = mysql_query("SELECT sum(goals) as tot_goal,  sum(assists) as tot_asst, 
                        sum(penalties) as tot_pen, sum(penmin) as tot_min FROM pwstats") 
      or

die(mysql_error());

    $num = mysql_num_rows($sql);

    if (empty($num))
      die('No records found');

    echo '
      <table border="4" width="100%" cellspacing="2" cellpadding="4">

        <tr align="center">
          <td>
            <b>TEAM</b>
          </td>
          <td>
            <b>GOALS</b>
          </td>
          <td>
            <b>ASSISTS</b> 
          </td>
          <td>
            <b>PENALTIES</b>
          </td>
          <td>
            <b>PENALTY MINUTES</b>
          </td>
        </tr>';

    while ($row = mysql_fetch_assoc($sql))
    {

    echo '
        <tr>
          <font color="#000000">
          <td align="center">TOTALS</td>
          <td align="center">',$row['tot_goal'],'</td>

          <td align="center">',$row['tot_asst'],'</td>

          <td align="center">',$row['tot_pen'],'</td>
          <td align="center">',$row['tot_min'],'</td></font>
        </tr>';

    }

    echo '

      </table>';
  ?>
  <br>
  <br>
  <?php
    $host="localhost";
    $usrnm="XXXXXXXX";
    $passwrd="XXXXXXXX";
    $database="XXXXXXXX";

    $tablename="pwgoalie";

    $jersey=$_GET["jersey"];
    $firstname=$_GET["firstname"];
    $lastname=$_GET["lastname"];
    $date=$_GET["date"];
    $gametime=$_GET["gametime"];
    $goals=$_GET["goals"];
    $saves=$_GET["saves"];
    $savepct=$_GET["savepct"];

    $con= mysql_connect($host,$usrnm,$passwrd)
      or die("Connection failed!!!");

    $varselect=mysql_select_db($database)
      or die("Database selection failed!!!");

    $sql = mysql_query("SELECT`jersey`, sum(goals) as tot_goal,  sum(saves) as tot_saves FROM pwgoalie GROUP BY jersey") 
      or

die(mysql_error());

    $saves2 = tot_saves;
    $goals2 = tot_goal;
    $total = ($saves2 + $goals2);
    $tot_pct = ($saves2/$total) * 100;

    $num = mysql_num_rows($sql);

    if (empty($num))
      die('No records found');

    echo '
      <table border="4" width="100%" cellspacing="2" cellpadding="4">

        <tr align="center">
          <td>
            <b>PLAYER</b>
          </td>
          <td>
            <b>GOALS</b>
          </td>
          <td>
            <b>SAVES</b> 
          </td>
          <td>
            <b>SAVE PCT</b>
          </td>
        </tr>';

    while ($row = mysql_fetch_assoc($sql))
    {

    echo '
        <tr>
          <font color="#000000">
          <td align="center">',$row['jersey'],'</td>
          <td align="center">',$row['tot_goal'],'</td>
          <td align="center">',$row['tot_saves'],'</td>
          <td align="center">',$row['$tot_pct'],'</td></font>
        </tr>';

    }

    echo '

      </table>';
  ?>

dalecosp

Hi, lyndon...

If you can do a couple of wee things, you may get a better response. One, if possible, only include the portions of code that are producing the errors, if you know what portions those are. If not, no biggie.

Secondly, the board supports syntax highlighting, which is most useful for PHP code. You'll note a button on the post editor for that --- or, it's as simple as using opening and closing tags: [php] $your_code_here; [/php] ...

Now, I'm not trying to be a snob; I've just been around a while, and know what makes a post work better for those of us with questions... hopefully, we can get an answer here that helps.

As for your real issues...you might want to use the [man]number_format/man to display your $penmin variable. Try using it --- if it still doesn't format correctly, then we know it's not a simple problem with print/echo.

It could be that you are mixing variable types in an operation. For example, mixing a float with an integer will result in an integer, IIRC. Check the values of all your variables by printing them, or using print_r or [man]var_dump/man and see if maybe this is the issue....

HTH,

dalecosp

And, of course, when I say "mixing a float with an integer", I mean, adding a float to an integer, dividing a float by an integer, multiplying a float and integer, etc....

"mixing" is for bartenders and DJ's, methinks....