[Web-erp-svn] SF.net SVN: web-erp:[7269] trunk/SelectSupplier.php

[<aga...@us...>]

Revision: 7269
          http://sourceforge.net/p/web-erp/reponame/7269
Author:   agaluski
Date:     2015-04-20 12:44:02 +0000 (Mon, 20 Apr 2015)
Log Message:
-----------
Fix SQL (change '==' to '=')

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

Modified: trunk/SelectSupplier.php
===================================================================
--- trunk/SelectSupplier.php	2015-04-19 14:57:47 UTC (rev 7268)
+++ trunk/SelectSupplier.php	2015-04-20 12:44:02 UTC (rev 7269)
@@ -371,7 +371,7 @@
 			$DataResult = DB_query($sql, $ErrMsg);
 			$myrow = DB_fetch_array($DataResult);
 			// Select some more data about the supplier
-			$SQL = "SELECT SUM(ovamount) AS total FROM supptrans WHERE supplierno = '" . $_SESSION['SupplierID'] . "' AND (type == '20' OR type='21')";
+			$SQL = "SELECT SUM(ovamount) AS total FROM supptrans WHERE supplierno = '" . $_SESSION['SupplierID'] . "' AND (type = '20' OR type='21')";
 			$Total1Result = DB_query($SQL);
 			$row = DB_fetch_array($Total1Result);
 			echo '<br />';