[Weberp-svn] SF.net SVN: weberp:[4182] trunk/BankAccounts.php

[<sot...@us...>]

Revision: 4182
          http://weberp.svn.sourceforge.net/weberp/?rev=4182&view=rev
Author:   sotandeka
Date:     2011-01-09 10:19:07 +0000 (Sun, 09 Jan 2011)

Log Message:
-----------
Correct the quotes in SQL literals

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

Modified: trunk/BankAccounts.php
===================================================================
--- trunk/BankAccounts.php	2011-01-09 10:06:22 UTC (rev 4181)
+++ trunk/BankAccounts.php	2011-01-09 10:19:07 UTC (rev 4182)
@@ -82,7 +82,7 @@
 
 		/*Check if there are already transactions against this account - cant allow change currency if there are*/
 
-		$sql = 'SELECT * FROM banktrans WHERE bankact=' . $SelectedBankAccount;
+		$sql = "SELECT * FROM banktrans WHERE bankact=" . $SelectedBankAccount;
 		$BankTransResult = DB_query($sql,$db);
 		if (DB_num_rows($BankTransResult)>0) {
 			$sql = "UPDATE bankaccounts
@@ -336,7 +336,7 @@
 if (!isset($_POST['CurrCode']) OR $_POST['CurrCode']==''){
 	$_POST['CurrCode'] = $_SESSION['CompanyRecord']['currencydefault'];
 }
-$result = DB_query('SELECT currabrev, currency FROM currencies',$db);
+$result = DB_query("SELECT currabrev, currency FROM currencies",$db);
 while ($myrow = DB_fetch_array($result)) {
 	if ($myrow['currabrev']==$_POST['CurrCode']) {
 		echo '<option selected VALUE=';
@@ -355,7 +355,7 @@
 }
 
 if (isset($SelectedBankAccount)) {
-	$result = DB_query('SELECT invoice FROM bankaccounts where accountcode =' . $SelectedBankAccount ,$db);
+	$result = DB_query("SELECT invoice FROM bankaccounts where accountcode =" . $SelectedBankAccount ,$db);
 	while ($myrow = DB_fetch_array($result)) {
 		if ($myrow['invoice']== 1) {
 			echo '<option selected VALUE=1>'._('Yes').'</option><option value=0>'._('No').'</option>';


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