[Weberp-svn] SF.net SVN: weberp:[4171] trunk/GLJournal.php

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

Revision: 4171
          http://weberp.svn.sourceforge.net/weberp/?rev=4171&view=rev
Author:   tim_schofield
Date:     2011-01-09 09:57:44 +0000 (Sun, 09 Jan 2011)

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

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

Modified: trunk/GLJournal.php
===================================================================
--- trunk/GLJournal.php	2011-01-09 09:57:34 UTC (rev 4170)
+++ trunk/GLJournal.php	2011-01-09 09:57:44 UTC (rev 4171)
@@ -203,7 +203,7 @@
 			if (!isset($_POST['GLAmount'])) {
 				$_POST['GLAmount']=0;
 			}
-			$SQL = 'SELECT accountname FROM chartmaster WHERE accountcode=' . $_POST['GLCode'];
+			$SQL = "SELECT accountname FROM chartmaster WHERE accountcode='" . $_POST['GLCode'] . "'";
 			$Result=DB_query($SQL,$db);
 			$myrow=DB_fetch_array($Result);
 			$_SESSION['JournalDetail']->add_to_glanalysis($_POST['GLAmount'], $_POST['GLNarrative'], $_POST['GLCode'], $myrow['accountname'], $_POST['tag']);


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