Moderators note: Please write new text below original text.
On Jan 23, 2008 12:02 PM, O'Brien, Kevin <[EMAIL PROTECTED]> wrote:
> Hi guys,
>
> I am very new to using PHP and am working on my first site so I'm sorry
> if this question is trivial. I have created a table that returns the
> first row from a table. It has the date in the first column and then
> five more columns with numbers. I would like to get the sum of those
> five columns. Any help would be greatly appreciated!
>
> I'm pasting my code below.
>
> Thank you.
>
> Kevin
>
> All my code. Generated with Dreamweaver...
>
> <?php require_once('Connections/connExchangeDB.php'); ?>
>
> <?php
>
> if (!function_exists("GetSQLValueString")) {
>
> function GetSQLValueString($theValue, $theType, $theDefinedValue = "",
> $theNotDefinedValue = "")
>
> {
>
> $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) :
> $theValue;
>
> $theValue = function_exists("mysql_real_escape_string") ?
> mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
>
> switch ($theType) {
>
> case "text":
>
> $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
>
> break;
>
> case "long":
>
> case "int":
>
> $theValue = ($theValue != "") ? intval($theValue) : "NULL";
>
> break;
>
> case "double":
>
> $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" :
> "NULL";
>
> break;
>
> case "date":
>
> $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
>
> break;
>
> case "defined":
>
> $theValue = ($theValue != "") ? $theDefinedValue :
> $theNotDefinedValue;
>
> break;
>
> }
>
> return $theValue;
>
> }
>
> }
>
> $maxRows_Edrive = 1;
>
> $pageNum_Edrive = 0;
>
> if (isset($_GET['pageNum_Edrive'])) {
>
> $pageNum_Edrive = $_GET['pageNum_Edrive'];
>
> }
>
> $startRow_Edrive = $pageNum_Edrive * $maxRows_Edrive;
>
> mysql_select_db($database_connExchangeDB, $connExchangeDB);
>
> $query_Edrive = "SELECT servers.`Date`, servers.exchangemb1e,
> servers.exchangemb2e, servers.exchangemb3e, servers.exchangemb4e,
> servers.exchangemb5e FROM servers ORDER BY servers.`Date` DESC";
>
> $query_limit_Edrive = sprintf("%s LIMIT %d, %d", $query_Edrive,
> $startRow_Edrive, $maxRows_Edrive);
>
> $Edrive = mysql_query($query_limit_Edrive, $connExchangeDB) or
> die(mysql_error());
>
> $row_Edrive = mysql_fetch_assoc($Edrive);
>
> if (isset($_GET['totalRows_Edrive'])) {
>
> $totalRows_Edrive = $_GET['totalRows_Edrive'];
>
> } else {
>
> $all_Edrive = mysql_query($query_Edrive);
>
> $totalRows_Edrive = mysql_num_rows($all_Edrive);
>
> }
>
> $totalPages_Edrive = ceil($totalRows_Edrive/$maxRows_Edrive)-1;
>
> ?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
>
> <html xmlns="http://www.w3.org/1999/xhtml";><!-- InstanceBegin
> template="Templates/template.dwt.php" codeOutsideHTMLIsLocked="false"
> -->
>
> <head>
>
> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
>
> <!-- InstanceBeginEditable name="doctitle" -->
>
> <title>Exchange at BNL - Todays Disk Usage</title>
>
> <!-- InstanceEndEditable -->
>
> <!-- InstanceBeginEditable name="head" -->
>
> <style type="text/css">
>
> <!--
>
> .style3 {font-size: x-small}
>
> -->
>
> </style><!-- InstanceEndEditable -->
>
> <link href="twoColLiqLtHdr.css" rel="stylesheet" type="text/css" />
>
> <!--[if IE]>
>
> <style type="text/css">
>
> /* place css fixes for all versions of IE in this conditional comment */
>
> .twoColLiqLtHdr #sidebar1 { padding-top: 30px; }
>
> .twoColLiqLtHdr #mainContent { zoom: 1; padding-top: 15px; }
>
> /* the above proprietary zoom property gives IE the hasLayout it needs
> to avoid several bugs */
>
> </style>
>
> <![endif]-->
>
> <script src="SpryAssets/SpryMenuBar.js" type="text/javascript"></script>
>
> <link href="SpryAssets/SpryMenuBarVertical.css" rel="stylesheet"
> type="text/css" />
>
> <style type="text/css">
>
> ul.MenuBarVertical
>
> {
>
> margin: 0 auto ;
>
> width: 8em;
>
> }
>
> </style>
>
> </head>
>
> <body class="twoColLiqLtHdr">
>
> <div id="container">
>
> <div id="header">
>
> <h1 align="center">Exchange</h1>
>
> <!-- end #header --></div>
>
> <div id="sidebar1">
>
> <ul id="MenuBar1" class="MenuBarVertical">
>
> <li><a href="index.php">Home</a> </li>
>
> <li><a href="#" class="MenuBarItemSubmenu">Disk Usage</a>
>
> <ul>
>
> <li><a href="current.php">Current Stats</a></li>
>
> <li><a href="MaxDays.php">Historical</a></li>
>
> </ul>
>
> </li>
>
> </ul>
>
> <p> </p>
>
> </div>
>
> <div id="mainContent"><!-- InstanceBeginEditable name="Body" -->
>
> <div align="center">
>
> <h4>Total Disk Usage Of All Databases by Server (GB)</h4>
>
> </div>
>
> <table border="1" align="center">
>
> <tr>
>
> <td><div align="center"><span
> class="style3"><strong>Date</strong></span></div></td>
>
> <td><span class="style3"><strong>exchangemb1e</strong></span></td>
>
> <td><span class="style3"><strong>exchangemb2e</strong></span></td>
>
> <td><span class="style3"><strong>exchangemb3e</strong></span></td>
>
> <td><div align="center"><span
> class="style3"><strong>exchangemb4e</strong></span></div></td>
>
> <td><span class="style3"><strong>exchangemb5e</strong></span></td>
>
> </tr>
>
> <?php do { ?>
>
> <tr>
>
> <td><div align="center"><span class="style3"><?php echo
> $row_Edrive['Date']; ?></span></div></td>
>
> <td><div align="center"><span class="style3"><?php echo
> $row_Edrive['exchangemb1e']; ?></span></div></td>
>
> <td><div align="center"><span class="style3"><?php echo
> $row_Edrive['exchangemb2e']; ?></span></div></td>
>
> <td><div align="center"><span class="style3"><?php echo
> $row_Edrive['exchangemb3e']; ?></span></div></td>
>
> <td><div align="center"><span class="style3"><?php echo
> $row_Edrive['exchangemb4e']; ?></span></div></td>
>
> <td><div align="center"><span class="style3"><?php echo
> $row_Edrive['exchangemb5e']; ?></span></div></td>
>
> </tr>
>
> <?php } while ($row_Edrive = mysql_fetch_assoc($Edrive)); ?>
>
> </table>
>
> <!-- InstanceEndEditable --></div>
>
> <!-- This clearing element should immediately follow the
> #mainContent div in order to force the #container div to contain all
> child floats --><br class="clearfloat" />
>
> <div id="footer">
>
> <p><a href="index.php"><img src="images/exchange_logo.JPG" alt="Home
> Page" width="48" height="41" border="0" /></a></p>
>
> <!-- end #footer --></div>
>
> <!-- end #container --></div>
>
> <script type="text/javascript">
>
> <!--
>
> var MenuBar1 = new Spry.Widget.MenuBar("MenuBar1",
> {imgRight:"../SpryAssets/SpryMenuBarRightHover.gif"});
>
> //-->
>
> </script>
>
> </body>
>
> <!-- InstanceEnd --></html>
>
> <?php
>
> mysql_free_result($Edrive);
>
> ?>
>
--------------------------------
hi,
you can try to change this query
$query_Edrive = "SELECT servers.`Date`, servers.exchangemb1e,
servers.exchangemb2e, servers.exchangemb3e, servers.exchangemb4e,
servers.exchangemb5e FROM servers ORDER BY servers.`Date` DESC";
to
$query_Edrive = "SELECT servers.`Date`, servers.exchangemb1e +
servers.exchangemb2e + servers.exchangemb3e + servers.exchangemb4e +
servers.exchangemb5e FROM servers ORDER BY servers.`Date` DESC";
i think that solves yout problem.
sorry about my english, i'm newbie.
--
Atenciosamente.
Gustavo Coutinho
http://gugarush.blogspot.com
