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]
