Update statement not working

[chigley]

I have a table called Product. I am executing an update statement which does not error and does not update the data either!

$query="UPDATE Product SET ProdName ='" . $this->prodName . "', ProductCategory_ProdCategory = '" . $this->ProductCategory->productCategory . "', ReleaseDate = '" . $this->releaseDate . "', ProdDescription = '". $this->prodDescription . "' WHERE Product_ProdId = " . $this->prodId;
$result=$db->executeQuery($query) or die(mysql_error());

The code produces the following update statement :

UPDATE Product SET ProdName ='Additional Garter1', ProductCategory_ProdCategory = 'GARTR', ReleaseDate = '2006-09-14 00:00:00', ProdDescription = 'Some Desc1' WHERE Product_ProdId = 19

Any ideas?

 

[sleipnir214]

If an update statement does not produce an error, chance are it's well-formed.

If a well-formed update statement with a WHERE clause does not update any records, chances are it's because no records match the WHERE clause.




Want the best answers? Ask the best questions! TANSTAAFL!

 

[chigley]

Trust me, there is a prodid 19.

 

[sleipnir214]

What is the column-type of Product_ProdId?



Want the best answers? Ask the best questions! TANSTAAFL!

 

[towerbase]

What is output after executing

SELECT * FROM Product WHERE Product_ProdId=19

and what is the output after executing

DESC Product

using something like MySQL Query Browser?

Andrew
Hampshire, UK