[Weberp-svn] SF.net SVN: weberp:[4290] trunk

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

Revision: 4290
          http://weberp.svn.sourceforge.net/weberp/?rev=4290&view=rev
Author:   tim_schofield
Date:     2011-01-13 19:32:09 +0000 (Thu, 13 Jan 2011)

Log Message:
-----------
Remove unnecessary year and month from options

Modified Paths:
--------------
    trunk/SupplierBalsAtPeriodEnd.php
    trunk/includes/SQL_CommonFunctions.inc

Modified: trunk/SupplierBalsAtPeriodEnd.php
===================================================================
--- trunk/SupplierBalsAtPeriodEnd.php	2011-01-13 18:38:17 UTC (rev 4289)
+++ trunk/SupplierBalsAtPeriodEnd.php	2011-01-13 19:32:09 UTC (rev 4290)
@@ -143,12 +143,12 @@
 	$Periods = DB_query($sql,$db,$ErrMsg);
 
 	while ($myrow = DB_fetch_array($Periods,$db)){
-		 if ($myrow['YearMonth'] == date("Ym")) {  // get the current month 
-		  
+		 if ($myrow['YearMonth'] == date("Ym")) {  // get the current month
+
 		  echo '<option VALUE=' . $myrow['lastdate_in_period'] . ' selected="TRUE">' . MonthAndYearFromSQLDate($myrow['lastdate_in_period'],'M',-1);
 		 }
-		else { 
-		   echo '<option VALUE=' . $myrow['lastdate_in_period'] . '> '.$myrow['YearMonth'].' '.MonthAndYearFromSQLDate($myrow['lastdate_in_period']).'</option>';
+		else {
+		   echo '<option VALUE=' . $myrow['lastdate_in_period'] . '> '.MonthAndYearFromSQLDate($myrow['lastdate_in_period']).'</option>';
 	    }
 	   }
 	echo '</select></td></tr>';
@@ -159,4 +159,4 @@
 	include('includes/footer.inc');
 }/*end of else not PrintPDF */
 
-?>
+?>
\ No newline at end of file

Modified: trunk/includes/SQL_CommonFunctions.inc
===================================================================
--- trunk/includes/SQL_CommonFunctions.inc	2011-01-13 18:38:17 UTC (rev 4289)
+++ trunk/includes/SQL_CommonFunctions.inc	2011-01-13 19:32:09 UTC (rev 4290)
@@ -237,7 +237,7 @@
 	while ($MyRow=DB_fetch_array($result)){
 		$NewParent = $MyRow['parent'];
 		$MaterialCost = BomMaterialCost($NewParent, $db);
-		$SQL = 'UPDATE stockmaster SET materialcost=' . $MaterialCost . " WHERE stockid='" . $NewParent . "'";
+		$SQL = "UPDATE stockmaster SET materialcost='" . $MaterialCost . "' WHERE stockid='" . $NewParent . "'";
 		$result1 = DB_query($SQL,$db);
 		if (DB_error_no($db)!=0) {
 			return 1;


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