Edit / Update Query - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

Edit / Update Query

Author

Topic

anonymousmofo
Starting Member

2 Posts

Posted - 2012-04-11 : 07:48:01

Hi Guys,
I am currently working on a website that deals with sales of products. For one of my pages for the website I need it to be able to change the current sales information for a specific product.

The top part of the following code selects the specific product however I cannot get the update query to work.

Can anybody help please?

Thank you

$describeQuery = "SELECT p.ID, p.NAME, dt.[Year], dt.[Month], dt.SalesVolume FROM Products p
						join
						(select ProductCode, sum(SalesVolume) as SalesVolume, [Year], [Month] from MonthlySales 						
						group by ProductCode, [Year], [Month])dt
						on dt.ProductCode = p.ID WHERE [NAME] = '$desiredProduct' AND [Year] = '$desiredYear' AND [Month] = '$desiredMonth'";



	$editQuery = "UPDATE MonthlySales SET SalesVolume = '$NewSales' WHERE ID = '$desiredProduct' AND Year = '$desiredYear' AND Month = '$desiredMonth'";


	$query = sqlsrv_query($link, $describeQuery);

Xiez
Starting Member

13 Posts

Posted - 2012-04-11 : 17:24:02

Well you're using $desiredProduct as a NAME field in the SELECT statement, but an ID field in the UPDATE statement... could that be it?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-04-12 : 00:30:41

where are you capturing value of $NewSales from first select?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources