Ok I got a query.
$query_att = "SELECT id,t.name, pe.points_earned AS points, pu.points_spent AS loot, 100*30dayattendance AS 30day , 100*60dayattendance AS 60day,
pu.points_spent/pe.points_earned AS ratio
FROM 60dayatt AS s, `30dayatt` AS t, Points_Earned AS pe, Points_Used AS pu, Member_List AS m
WHERE s.name=t.name AND s.name=pe.name AND s.name=pu.name AND s.name=m.name AND t.name=m.name AND pe.name=pu.name AND active='1'
GROUP BY t.name, s.name, m.name, pe.name, pu.name";
$att = mysql_query($query_att, $db) or die(mysql_error());
$row_att = mysql_fetch_assoc($att);
$totalRows_att = mysql_num_rows($att);
I then output the results with
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="6"><div align="center"><span class="style6">All Raid Attendance </span></div></td>
</tr>
<tr>
<td><span class="style2">Name </span> </td>
<td><span class="style2">Raid Points </span></td>
<td><span class="style2">Loot Pts Charged </span></td>
<td><span class="style2">Ratio Here</span></td>
<td><span class="style2">60 Day Att</span></td>
<td><span class="style2">30 Day Att</span></td>
</tr>
<?php do { ?>
<tr>
<td width="15%"><span class="style2"><a href="<?PHP echo "index.php?categoryid=15&id=" . $row_att['id'] .""; ?>"><?php echo $row_att['name']; ?></a></span></td>
<td width="15%"><span class="style2"><?php echo $row_att['points']; ?></span></td>
<td width="15%"><span class="style2"><?php echo $row_att['loot']; ?></span></td>
<td width="15%"><span class="style2">
<?php
$num = $row_att['loot']/$row_att['points'];
if ($row_att['60day'] <= 49) {
echo round($num+((50-$row_att['60day'])/50), 3);
} else {
echo round($num, 3);
}
?>
</span></td>
<td width="15%"><span class="style2"><?php echo round($row_att['60day'],0); ?>%</span></td>
<td width="15%"><span class="style2"><?php echo round($row_att['30day'],0); ?>%</span></td>
</tr>
<?php } while ($row_att = mysql_fetch_assoc($att)); ?>
</table>
Now what i wanna do is take the results from the table produced and create a table in MYSQL with the results that are displayed. (not the results the SQL gives) As you can see the ratio field is altered after its query using PHP.
