one problem on the second script you are trying to use variables that are in
an array.
if this is where you are talking about
you need to specify the array[key]
> while ($myrow=DB_fetch_array($result)){
>
>
> $difference = ($budget - $actual);
$difference = ($myrow[budget] - $myrow[actual]);
>
>
>
printf("<TR><TD>%s</TD><TD>%s</TD><TD>%s</TD><TD>%s</TD><TD>%s</TD><TD>%s</T
----- Original Message -----
From: "Michael O'Neal" <[EMAIL PROTECTED]>
To: " "Php-General@Lists. Php. Net"" <[EMAIL PROTECTED]>
Sent: Wednesday, October 24, 2001 1:18 PM
Subject: [PHP] Trying to subtract...no luck. (Long Code)
> Hi. I'm trying to figure out how to subtract 1 variable from another, but
> I'm not having any luck.
>
> It works on this page:
>
>
> <?php
>
> $db_name = "comanche";
> $table_name = "ProjectTasks";
>
> $connection = @mysql_connect("$db","$user","$pass") or die("Couldn't
> Connect.");
> $db = @mysql_select_db($db_name, $connection) or die("Couldn't select
> database.");
>
> $sql ="SELECT budget,actual FROM $table_name";
>
> $result = @mysql_query($sql, $connection) or die("Couldn't execute
query.");
>
> while ($row = mysql_fetch_array($result)) {
> $budget=$row['budget'];
> $actual=$row['actual'];
> $difference = ($budget - $actual);
>
>
> echo "$budget - $actual = $difference<br>";
>
> }
>
>
> $num = @mysql_num_rows($result);
>
> ?>
>
>
> But not on this page:
>
> ---------------BEGIN LONG PHP STUFF ----------------------
>
> <?php
>
>
> $title = "Tasks Maintenance";
> include("../inc/hdr.php");
> include("header.inc");
> include("DateFunctions.inc");
>
>
> if (!isset($ProjectID)){
>
> echo "<P>This page must be called from the projects list page with the
> tasks link. Alternatively, you can enter the link as
> Tasks.php?ProjectID=<i>ProjectID number</i><P><A HREF='" . $rootpath .
> "/Projects.php'>Project List</A>";
> exit;
> }
>
> if ($submit) {
>
> //initialise no input errors assumed initially before we test
> $InputError = 0;
>
> /* actions to take once the user has clicked the submit button
> ie the page has called itself with some user input */
>
> //first off validate inputs sensible
>
> if (strlen($TaskName) > 50 OR strlen($TaskName)==0) {
> $InputError = 1;
> echo "<BR>The task name must be entered and be fifty characters or
> less long";
> } elseif (!is_date($EarliestStart)) {
> $InputError = 1;
> echo "<BR>The date the task was initiated must be specified in the
> format dd/mm/yyyy";
> } elseif (!is_numeric($ExpectedDuration) || $ExpectedDuration<0){
> $InputError = 1;
> echo "<BR>The expected duration of the task must be specified as a
> number - greater or equal to 0"; }
>
>
> if ($InputError !=1){
>
> $SQL_EarliestStart = FormatDateForSQL($EarliestStart);
>
> if (isset($SelectedTask)) {
>
>
>
> $sql = "UPDATE ProjectTasks SET TaskName='$TaskName',
> TaskDescription='$TaskDescription', EarliestStart='$SQL_EarliestStart',
> TaskChampion='$TaskChampion', ExpectedDuration=$ExpectedDuration,
> Status='$Status', budget='$budget', actual='$actual' WHERE TaskID =
> $TaskID";
>
> $result = DB_query($sql,$db);
> if (DB_error_no($db) !=0) {
> echo "The task could not be updated because - " .
> DB_error_msg($db) . " The SQL statement used for the update was:<BR>$sql";
> } else {
> echo "<P>task updated";
> unset($SelectedTask);
> unset($TaskName);
> unset($TaskDescription);
> unset($TaskChampion);
> unset($EarliestStart);
> unset($ExpectedDuration);
> unset($Status);
> unset($budget);
> unset($actual);
> }
>
> } else { //not a new task
>
>
>
> $sql = "INSERT INTO ProjectTasks (ProjectID, TaskName,
> TaskDescription, EarliestStart, TaskChampion, ExpectedDuration, Status,
> budget, actual) VALUES ($ProjectID, '$TaskName', '$TaskDescription',
> '$SQL_EarliestStart', '$TaskChampion', $ExpectedDuration, '$Status',
> '$budget', '$actual')";
>
> $result = DB_query($sql,$db);
> if (DB_error_no($db) !=0) {
> echo "The task could not be added because - " .
> DB_error_msg($db) . " the SQL used to insert the new task was:<BR>" .
$sql;
> } else {
> echo "<P>Task inserted";
> unset($TaskName);
> unset($TaskDescription);
> unset($TaskChampion);
> unset($EarliestStart);
> unset($ExpectedDuration);
> unset($Status);
> unset($budget);
> unset($actual);
> }
> }
> } else {
> echo "<BR>Validation failed, no updates or deletes took place.";
> }
>
> } elseif ($delete) {
> //the link to delete a selected record was clicked instead of the submit
> button
>
> $sql="DELETE FROM ProjectTasks WHERE TaskID=$TaskID";
> $result = DB_query($sql,$db);
>
> $sql="DELETE FROM TaskDependancies WHERE TaskID=$TaskID";
> $result = DB_query($sql,$db);
>
> $sql="DELETE FROM TaskDependancies WHERE RequiresTaskID=$TaskID";
> $result = DB_query($sql,$db);
>
> echo "<P>Task Deleted ! <p>";
> unset($SelectedTask);
> unset($TaskName);
> unset($TaskDescription);
> unset($TaskChampion);
> unset($EarliestStart);
> unset($ExpectedDuration);
> unset($Status);
> unset($budget);
> unset($actual);
> }
>
>
> /*Show some details about the master task for which tasks are being
> maintained */
>
> $sql = "SELECT ProjectName, ProjectDescription, PlayerName, PlayerEmail
FROM
> ProjectMaster, Players WHERE ProjectMaster.Champion = Players.PlayerID AND
> ProjectID =" . $ProjectID;
>
> $result = DB_query($sql,$db);
> $myrow = DB_fetch_array($result,$db);
>
>
>
> echo "<P><TABLE BORDER=0><TR><TD>Project: <A HREF='" . $rootpath .
> "/gaant.php?ProjectID=" . $ProjectID . "'><B>" . $myrow["ProjectName"] .
> "</B></A><BR>Project Lead: <A HREF='mailto:"; . $myrow["PlayerEmail"] .
"'>"
> . $myrow["PlayerName"] . "</A><P>" . $myrow["ProjectDescription"] .
> "</TD></TR></TABLE>";
>
>
> /*Show tasks underway for modification or viewing status*/
>
>
>
> $sql = "SELECT TaskID, TaskName, DATE_FORMAT(EarliestStart,'%d/%m/%Y') AS
> FmtEarliestStart, ExpectedDuration, PlayerName, Status, budget, actual
FROM
> ProjectTasks, Players WHERE ProjectTasks.TaskChampion=Players.PlayerID AND
> ProjectTasks.ProjectID=" . $ProjectID;
> $result = DB_query($sql, $db);
>
>
>
> if (DB_num_rows($result)!=0) {
>
> echo "<p><table border=\"0\" cellpadding=\"5\"><tr>
> <td><B>Task</B></td>
> <td><B>Earliest Start</B></td>
> <td><B>Duration</B></td>
> <td><B>Project Lead</B></td>
> <td><B>Status</B></td>
> <td><B>Budget</B></td>
> <td><B>Actual</B></td>
> <td><B>Difference</B></td></tr>\n\n";
>
>
>
>
> while ($myrow=DB_fetch_array($result)){
>
>
> $difference = ($budget - $actual);
>
>
>
printf("<TR><TD>%s</TD><TD>%s</TD><TD>%s</TD><TD>%s</TD><TD>%s</TD><TD>%s</T
> D><TD>%s</TD><TD>%s</TD><TD><A
> HREF='%s?SelectedTask=%s&ProjectID=%s'>Edit</A></TD><TD><A
> HREF='%s/TaskDeps.php?TaskID=%s'>Dependancies</A></TD></TR>\n",
> $myrow["TaskName"],
> $myrow["FmtEarliestStart"],
> $myrow["ExpectedDuration"],
> $myrow["PlayerName"],
> $myrow["Status"],
> $myrow["budget"],
> $myrow["actual"],
> $difference,
> $PHP_SELF,
> $myrow["TaskID"],
> $ProjectID,
> $rootpath,
> $myrow["TaskID"] );
>
> }
>
> echo "</TABLE><HR>\n\n";
>
> }
>
>
> echo "<FORM METHOD='post' action=" . $PHP_SELF . ">";
> echo "<CENTER><TABLE>\n";
>
> echo "<INPUT TYPE=HIDDEN NAME='ProjectID' VALUE=$ProjectID>";
>
> If ($SelectedTask) {
>
> $difference = ($budget - $actual);
>
> $sql = "SELECT TaskName, TaskDescription, EarliestStart,
> ExpectedDuration, TaskChampion, Status, budget, actual FROM ProjectTasks
> WHERE TaskID=$SelectedTask";
> $result = DB_query($sql, $db);
> $myrow = DB_fetch_array($result);
>
> $TaskName = $myrow["TaskName"];
> $TaskDescription = $myrow["TaskDescription"];
> $EarliestStart = ConvertSQLDate($myrow["EarliestStart"]);
> $TaskChampion = $myrow["TaskChampion"];
> $ExpectedDuration=$myrow["ExpectedDuration"];
> $Status = $myrow["Status"];
> $budget = $myrow["budget"];
> $actual = $myrow["actual"];
> $difference = ($budget - $actual);
>
>
> echo "<INPUT TYPE=HIDDEN NAME='TaskID' VALUE=$SelectedTask>";
> echo "<INPUT TYPE=HIDDEN NAME='SelectedTask' VALUE=$TaskID>";
> }
>
> echo "<TR><TD>Task Name:</TD><TD><input type='Text' name='TaskName'
> value='$TaskName' SIZE=52 MAXLENGTH=50></TD></TR>\n";
> echo "<TR><TD>Task Description:</TD><TD><textarea name='TaskDescription'
> cols=50 rows=8>$TaskDescription</textarea></TD></TR>\n";
>
>
> if (!$SelectedTask) {
> $EarliestStart = Date("d/m/Y");
> }
>
> echo "<TR><TD>Earliest Start Date (dd/mm/yyyy):</TD><TD><input type='Text'
> name='EarliestStart' value=$EarliestStart SIZE=12
> MAXLENGTH=10></TD></TR>\n";
>
> echo "<TR><TD>Expected Duration ($DurationName):</TD><TD><input
type='Text'
> SIZE=5 MAXLENGTH=5 name='ExpectedDuration'
> value=$ExpectedDuration></TD></TR>\n";
>
> echo "<TR><TD>Project Lead:</TD><TD><SELECT name='TaskChampion'>";
>
> $sql = "SELECT PlayerID, PlayerName FROM Players";
> $result=DB_query($sql,$db);
>
> while ($myrow=DB_fetch_array($result)){
> if ($myrow["PlayerID"]==$TaskChampion){
> echo "<OPTION SELECTED Value='" . $myrow["PlayerID"] . "'>" .
> $myrow["PlayerName"];
> } else {
> echo "<OPTION Value='" . $myrow["PlayerID"] . "'>" .
> $myrow["PlayerName"];
> }
> }
>
> echo "</SELECT></TD></TR>\n";
>
> echo "<TR><TD>Status:</TD><TD><SELECT name='Status'>";
>
> if ($Status=="Wait"){
> echo "<OPTION SELECTED Value='Wait'>Not Started";
> } else {
> echo "<OPTION Value='Wait'>Not Started";
> }
>
> if ($Status=="Started"){
> echo "<OPTION SELECTED Value='Started'>Started";
> } else {
> echo "<OPTION Value='Started'>Started";
> }
>
> if ($Status=="Complete"){
> echo "<OPTION SELECTED Value='Complete'>Complete";
> } else {
> echo "<OPTION Value='Complete'>Complete";
> }
>
> echo "</SELECT></TD></TR>\n";
>
> echo "<TR><TD>Projected Budget:</TD><TD><input type='Text' name='budget'
> value=$budget></TD></TR>\n";
>
> echo "<TR><TD>Actual Budget:</TD><TD><input type='Text' name='actual'
> value=$actual></TD></TR>\n";
>
> echo "<TR><TD>Budget
> Difference</TD><TD><b>$difference</b></font></TD></TR>\n";
>
>
> if (!$SelectedTask) {
> echo "</TABLE>\n\n<P><CENTER><input type='Submit' name='submit'
> value='Add New task'>\n</FORM>";
> } else {
> echo "</TABLE>\n\n<P><CENTER><input type='Submit' name='delete'
> value='Delete task'><input type='Submit' name='submit' value='Update
> task'></FORM>\n";
> }
>
> ?>
> <?php include "../inc/ftr.php" ?>
>
>
> ---------------- END PHP STUFF -------------------
>
> I can't figure out how to get the script working on this page. Where
should
> the variable definition go?
>
> Thanks for any help.
>
> If you can, please reply to [EMAIL PROTECTED], as I am on the digest.
>
>
>
>
> mto
>
> --
>
> Michael O'Neal
> Web Producer/ Autocrosser
> ST 28 '89 Civic Si
> ---------------------
> M A N G O
> B O U L D E R
> ---------------------
> http://www.thinkmango.com
> e- [EMAIL PROTECTED]
> p- 303.442.1821
> f- 303.938.8507
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
