PHP and some math :)

[Mark_Nordstrom]

Ok heres my issue. I wanna do something in php and not sure it can be done. Heres what i was thinking for query.

SELECT name, COUNT(pts)/COUNT(ptsused) AS ratio 

This isnt complete just throwing something together to give example of where im stuck. Theres also an attendance % column and my issue is if attendance <50% i need to add .01 from the ratio result for every 1% below 50 the attendance is. So if my ratio was .400 and my attendance was 25 % my ratio would come out as .425

Anyone have any idea how this could work ? Im stuck here and have no clue where to even start on this.

[dgdg]

try using CASE statement

[jkurrle]

Well, your statement looks good. Let's see what I can do with it...

fyi, I always write a Connect_To_DB() function to open and return a database connection. (So you don't get confused...)

$select="select name,attendence,count(pts)/count(ptsused) as ratio from some_table
  where some_condition=\"some_value\" ";
$connection=Connect_To_DB(); //database connection function
$result=mysql_query($select)
  or die("Select from some_table table had errors");
mysql_close($connection);

while ($row=mysql_fetch_array($result,MYSQL_ASSOC))
  {
  extract($row);
  $att_percent=$attendence/$roster_count; //$roster_count is the theoretical max
  $penalty=.5-$att_percent;
  if ($penalty>0) echo "Ratio for $name is " . $ratio-$penalty . "<br />";
  else echo "Ratio for $name is $ratio <br />"
  }

How's that grab ya?

[Mark_Nordstrom]

Trying it out now ill let you know, but it looks like its going in the right direction.

Another issue i was having using SUM.

 SELECT Attendance.name, SUM(pts), SUM(loot) FROM Attendance, Points_spent GROUP BY Attendance.name

This doesnt work. The SUMs come up totally wrong.

[Mark_Nordstrom]

$penalty=$row_att['ratio']+.01; 

if ($row_att['60day'] < 0.49) {
    echo $penalty;
} else {
    echo $row_att['ratio'];
}
?>

This is what ive tried and its not what i need really. I need it to add .01 to $row_att['ratio']; for every 1% below $row_att['60day']; So if

Ratio = 0.60
Att = 0.35

Fixed Ratio would = 0.615