dalton6275 Posted April 10, 2006 Share Posted April 10, 2006 Hello Everyone, I am currently programming a online reporting system and I am trying to minus a total outage percentage from 100 but im not doing something correctly. The code i have is below. [code]<?php$colname_Recordset1 = "1";if (isset($_GET['sla'])) { $colname_Recordset1 = (get_magic_quotes_gpc()) ? $_GET['sla'] : addslashes($_GET['sla']);}mysql_select_db($database_Dalton, $Dalton);$query_Recordset1 = sprintf("SELECT * FROM incidents WHERE SLA = '%s'", $colname_Recordset1);$Recordset1 = mysql_query($query_Recordset1, $Dalton) or die(mysql_error());$row_Recordset1 = mysql_fetch_assoc($Recordset1);$totalRows_Recordset1 = mysql_num_rows($Recordset1);?> #sets up the recordset in Dreamweaver<?php do { ?> <tr> <td> <a href="fypincidentedit.php?recordID=<?php echo $row_Recordset1['ID_NO']; ?>"> <?php echo $row_Recordset1['ID_NO']; ?> </a> </td> <td> <?php echo $row_Recordset1['severity']; ?> </td> <td> <?php echo $row_Recordset1['title']; ?> </td> <td> <?php echo $row_Recordset1['SLA']; ?> </td> <td> <?php echo $row_Recordset1['AccentureResp']; ?> </td> # creates table showing all the rows from the query. <? if ($row_Recordset1['AccentureResp'] = 'N') { $outagecalc = $row_Recordset1['UNIX_TIMESTAMP(outage_end)'] - $row_Recordset1['UNIX_TIMESTAMP(outage_start)']; $outagetime = $outagecalc / 60; $outageeffect = ($outagecalc / 42320) * $row_Recordset1['percentage']; $totouttime = $totouttime + $outageeffect; }; ?> # calculations that i am trying to perform on each row in the table that has AccentureResp field set to 'N'. <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?></tr></table>[/code]What i am trying to do is set the calculations to perform on each row that has AccentureResp = 'N', but i dont think that i have the correct code for performing the loop as it is telling me that $totoutime = 0 everytime which lead me to believe that the loop is not working correctly. Anyone know where i am going wrong??? Quote Link to comment Share on other sites More sharing options...
Barand Posted April 10, 2006 Share Posted April 10, 2006 UNIX_TIMESTAMP() is a MySql function for use within queries. You cannot use it in a php script (other than in the text of query) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.