From: <dai...@us...> - 2012-02-18 09:13:07
|
Revision: 4921 http://web-erp.svn.sourceforge.net/web-erp/?rev=4921&view=rev Author: daintree Date: 2012-02-18 09:13:01 +0000 (Sat, 18 Feb 2012) Log Message: ----------- Modified Paths: -------------- trunk/BankAccounts.php Modified: trunk/BankAccounts.php =================================================================== --- trunk/BankAccounts.php 2012-02-17 10:59:12 UTC (rev 4920) +++ trunk/BankAccounts.php 2012-02-18 09:13:01 UTC (rev 4921) @@ -178,9 +178,8 @@ bankaddress, currcode, invoice - FROM bankaccounts - INNER JOIN chartmaster - ON bankaccounts.accountcode = chartmaster.accountcode"; + FROM bankaccounts INNER JOIN chartmaster + ON bankaccounts.accountcode = chartmaster.accountcode"; $ErrMsg = _('The bank accounts set up could not be retrieved because'); $DbgMsg = _('The SQL used to retrieve the bank account details was') . '<br />' . $sql; @@ -262,8 +261,8 @@ bankaddress, currcode, invoice - FROM bankaccounts - WHERE bankaccounts.accountcode='" . $SelectedBankAccount . "'"; + FROM bankaccounts + WHERE bankaccounts.accountcode='" . $SelectedBankAccount . "'"; $result = DB_query($sql, $db); $myrow = DB_fetch_array($result); @@ -291,11 +290,10 @@ $sql = "SELECT accountcode, accountname - FROM chartmaster - LEFT JOIN accountgroups - ON chartmaster.group_ = accountgroups.groupname - WHERE accountgroups.pandl = 0 - ORDER BY accountcode"; + FROM chartmaster LEFT JOIN accountgroups + ON chartmaster.group_ = accountgroups.groupname + WHERE accountgroups.pandl = 0 + ORDER BY accountcode"; $result = DB_query($sql,$db); while ($myrow = DB_fetch_array($result)) { This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |