Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  ASP.NET  Update Database help

Author  Topic  sauder84 Starting Member 1 Post Posted - 2013-10-10 : 14:32:19 I am trying to update the database with the following code but I keep getting the following error "Incorrect syntax near the keyword 'where'. (severity 15)" And here is my code written in php: Thanks in advance for the help! FILE #1 <script language="javascript"> function reload(form) { var val=form.fn.options[form.fn.options.selectedIndex].value; var val2=form.itemcode.options[form.itemcode.options.selectedIndex].value; //var val3=form.price.options[form.price.options.selectedIndex].value; self.location='priceupdate2.php?fn=' + val + '&itemcode=' + val2 + '&price=' ; } </script> </head> <style type = "text/css"> body {color: #000080; background: #C0C0C0} </style> <center> <div id="wrapper"> <div id="header"> <center><h1>Customer Price Update</center></h1> </div> <div id="subheader"> <?php ?> </div> <div id="leftmenu"> <?php require_once('config.php'); ini_set('error_reporting', E_ALL ^ E_NOTICE); ini_set('display_errors', 'on'); $conn= mssql_connect($servername, $username, $password) or die ("Can't connect to SQL Server"); mssql_select_db($database, $conn) or die ("Can't connect to database"); $fnName=@$_GET['fnName']; $fn = $_GET['fn']; $itemcode=@$_GET['itemcode']; $price=@$_GET['price']; ///////// Getting the data from sql table for first list box////////// @$quer=mssql_query("Select fnname, fn from TESTING.DBO.feeds "); ///////////// End of query for first list box//////////// /////// for second drop down list we will check if fnname //is selected else we will display all the itemcodes///// if(isset($fn) and strlen($fn) > 0){ @$quer2=mssql_query("select itemcode from TESTING.DBO.feed_pricelist where fn = '$fn'"); }else{ $quer2=mssql_query("select itemcode from TESTING.DBO.feed_pricelist where fn = '$fn'"); } ////////// end of query for second itemcode drop down list box ///// third drop down box query again check if the //category has been selected else we will display all the subcategory //if(isset($itemcode) and strlen($itemcode) > 0){ //@$quer3=mssql_query("SELECT price FROM TESTING.DBO.feed_pricelist // where fn = '$fn' and itemcode = '$itemcode'"); //}else{ // $quer3=mssql_query("SELECT price FROM TESTING.DBO.feed_pricelist // where fn= '$fn' and itemcode = '$itemcode'"); } // //end of form//// echo "<form method=post name=f1 action='dd-check.php'>"; echo "<table> <tr><td>"; ////////// Starting of first drop downlist ///////// echo "Customer Name"; echo"</td><td>"; echo "<select name='fn' onchange=\"reload(this.form) \">"; if ($fn == ''){ echo "<option value=''>Select One</option>"; $selected = ''; while($result = mssql_fetch_array($quer)) { echo "<option value='$result[fn]' >$result[fnname]</option><br>";} }else { $sql = "select fn, fnname from TESTING.DBO.feeds where fn = '$fn'"; $resultsfn = mssql_query($sql); while($result = mssql_fetch_array($quer)) { if($result['fn']==$fn){ $selected = 'selected';} else{ $selected = '';} echo "<option value='$result[fn]' $selected>$result[fnname]</option><br>";} } echo "</select></td></tr><tr><td>"; ////////////////// This will end the first drop down list /////////// ////////////////// Starting of second drop downlist //////////////// echo "Item Code"; echo"</td><td>"; echo "<select name='itemcode' onchange=\"reload(this.form) \">"; if ($itemcode == ''){ echo "<option value=''>Select One</option>"; $selected1 = ''; while($result1 = mssql_fetch_array($quer2)) { echo "<option value='$result1[itemcode]' >$result1[itemcode]</option><br>";} }else { $sql2 = "select itemcode from TESTING.DBO.feed_pricelist where fn = '$fn'"; $resultsitem = mssql_query($sql2); while($result1 = mssql_fetch_array($quer2)) { if($result1['itemcode']==$itemcode){ $selected1 = 'selected';} else{ $selected1 = '';} echo "<option value='$result1[itemcode]' $selected1>$result1[itemcode]</option><br>";} //echo "<option value = '$resultsitemcode[itemcode]'> // $resultsitemcode[itemcode]</option>"."<BR>"; } echo "</select></td></tr><tr><td>"; ////////////////// This will end the second drop down list /////////// ///////////////// starting text box for price////// $sql3 = "select price from TESTING.DBO.feed_pricelist where fn = '$fn' and itemcode = '$itemcode' "; $resultprice = mssql_query($sql3); $resultpriceitem = mssql_fetch_array($resultprice); $price = $resultpriceitem['price']; if($price != ''){ echo " Current Price "; echo "</td><td>"; echo "$"; echo "$price" ; } echo "</select></td></tr><tr><td>"; echo "</form>"; ?> <?php echo '<html> <body> <div> <style type = "text/css"> </style> <form name = "input" action = "update_customer_price.php" method = "get"> Update Price </td><td><input type = "text" name = priceUpdate > <input type = "submit" value = "Update"> </div> </body> </html> ' ?> FILE#2 <head> <style type = "text/css"> body {color: #000080; background: #C0C0C0} </style> </head> <?php require_once('config.php'); ini_set('error_reporting', E_ALL ^ E_NOTICE); ini_set('display_errors', 'on'); $conn= mssql_connect($servername, $username, $password) or die ("Can't connect to SQL Server"); mssql_select_db($database, $conn) or die ("Can't connect to database"); $fn = $_POST['fn']; $itemcode = $_POST['itemcode']; $price = $_POST['price']; $sql = "UPDATE TESTING.DBO.feed_pricelist SET price = CONVERT(INT, price)"; $result = mssql_query($sql); $sql1 = "UPDATE TESTING.DBO.feed_pricelist SET fn = '$fn', itemcode = '$itemcode', price = $price where fn = '$fn' "; $result1 = mssql_query($sql1); echo $price; //echo "<h3> Customer Price has been updated</h3>" ?> <h3>Customer price has been updated!</h3> <h3>Do you need to update another?</h3> <form name="input" action="PriceUpdate2.php" method="post"> <input type="submit" value="Enter"></form>