[Resolved] does this look right?

[viveleroi0]

for a MySQL db, does this look right?

UPDATE Products SET ProdCat=\"$ProdCat\" AND SubCat=\"$SubCat2\" AND SubCat3=\"$SubCat3\" AND ProdName=\"$ProdName2\" AND ProdPrice=\"$ProdPrice\" AND ProdDesc=\"$ProdDesc2\" AND ProdMisc=\"$ProdMisc\" AND ProdImage=\"$ProdImage2\" WHERE ID=\"$ID\"

[stolzyboy]

for UPDATE, you don't use AND, you use commas like:

<?
$query = "update tablename set field = '$fieldvar', field2 = '$field3var';";
?>