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

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

Revision: 4107
          http://weberp.svn.sourceforge.net/weberp/?rev=4107&view=rev
Author:   tim_schofield
Date:     2011-01-08 17:19:09 +0000 (Sat, 08 Jan 2011)

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

Modified Paths:
--------------
    trunk/SMTPServer.php
    trunk/StockAdjustments.php

Modified: trunk/SMTPServer.php
===================================================================
--- trunk/SMTPServer.php	2011-01-08 17:18:57 UTC (rev 4106)
+++ trunk/SMTPServer.php	2011-01-08 17:19:09 UTC (rev 4107)
@@ -24,7 +24,7 @@
 	echo '<br>';
 }
 
-$sql='SELECT id,
+$sql="SELECT id,
 				host,
 				port,
 				heloaddress,
@@ -32,7 +32,7 @@
 				password,
 				timeout,
 				auth
-			FROM emailsettings';
+			FROM emailsettings";
 $result=DB_query($sql, $db);
 $myrow=DB_fetch_array($result);
 echo "<form method='post' action=" . $_SERVER['PHP_SELF'] . "?" . SID . ">";

Modified: trunk/StockAdjustments.php
===================================================================
--- trunk/StockAdjustments.php	2011-01-08 17:18:57 UTC (rev 4106)
+++ trunk/StockAdjustments.php	2011-01-08 17:19:09 UTC (rev 4107)
@@ -55,9 +55,9 @@
 		'" alt="" />' . ' ' . _('Select Item to Adjust') . '</p>';
 
 	if (strlen($_POST['StockText'])>0) {
-		$sql='SELECT stockid, description from stockmaster where description like "%'.$_POST['StockText'].'%"';
+		$sql="SELECT stockid, description from stockmaster where description like '%".$_POST['StockText']."%'";
 	} else {
-		$sql='SELECT stockid, description from stockmaster where stockid like "%'.$_POST['StockCode'].'%"';
+		$sql="SELECT stockid, description from stockmaster where stockid like '%".$_POST['StockCode']."%'";
 	}
 	$ErrMsg=_('The stock information cannot be retrieved because');
 	$DbgMsg=_('The SQL to get the stock description was');
@@ -339,7 +339,7 @@
 
 echo '<tr><td>'. _('Adjustment to Stock At Location').':</td><td><select name="StockLocation"> ';
 
-$sql = 'SELECT loccode, locationname FROM locations';
+$sql = "SELECT loccode, locationname FROM locations";
 $resultStkLocs = DB_query($sql,$db);
 while ($myrow=DB_fetch_array($resultStkLocs)){
 	if (isset($_SESSION['Adjustment']->StockLocation)){


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