[Web-erp-svn] SF.net SVN: web-erp:[5069] trunk/Departments.php

[<tim...@us...>]

Revision: 5069
          http://web-erp.svn.sourceforge.net/web-erp/?rev=5069&view=rev
Author:   tim_schofield
Date:     2012-03-12 00:44:28 +0000 (Mon, 12 Mar 2012)
Log Message:
-----------
Change incorrect table name

Modified Paths:
--------------
    trunk/Departments.php

Modified: trunk/Departments.php
===================================================================
--- trunk/Departments.php	2012-03-12 00:39:45 UTC (rev 5068)
+++ trunk/Departments.php	2012-03-12 00:44:28 UTC (rev 5069)
@@ -34,8 +34,8 @@
 		prnMsg( _('The Name of the Department should not be empty'), 'error');
 	}
 
-	if (isset($_POST['SelectedDepartmentID']) 
-		AND $_POST['SelectedDepartmentID']!='' 
+	if (isset($_POST['SelectedDepartmentID'])
+		AND $_POST['SelectedDepartmentID']!=''
 		AND $InputError !=1) {
 
 
@@ -51,8 +51,8 @@
 			prnMsg( _('This department name already exists.'),'error');
 		} else {
 			// Get the old name and check that the record still exist neet to be very careful here
-			
-			$sql = "SELECT description 
+
+			$sql = "SELECT description
 					FROM departments
 					WHERE departmentid = '" . $SelectedDepartmentID . "'";
 			$result = DB_query($sql,$db);
@@ -120,8 +120,8 @@
 } elseif (isset($_GET['delete'])) {
 //the link to delete a selected record was clicked instead of the submit button
 
-	
-	$sql = "SELECT description 
+
+	$sql = "SELECT description
 			FROM departments
 			WHERE departmentid = '" . $SelectedDepartmentID . "'";
 	$result = DB_query($sql,$db);
@@ -130,9 +130,9 @@
 	} else {
 		$myrow = DB_fetch_row($result);
 		$OldDepartmentName = $myrow[0];
-		$sql= "SELECT COUNT(*) 
-				FROM dispatch INNER JOIN departments 
-				ON dispatch.departmentid=departments.departmentid  
+		$sql= "SELECT COUNT(*)
+				FROM stockrequest INNER JOIN departments
+				ON stockrequest.departmentid=departments.departmentid
 				WHERE description " . LIKE . " '" . $OldDepartmentName . "'";
 		$result = DB_query($sql,$db);
 		$myrow = DB_fetch_row($result);

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.