Rob page wrote:
> I can't figure out for the life of me why this won't work... but I am such a newb, ots crazy..
What errors do you get?
> $query1 = "UPDATE products SET prodname ='$prodname' WHERE prod_id = '$editid'";
> $query2 = "UPDATE products SET proddesc = '$proddesc' WHERE prod_id = '$editid'";
> $query3 = "UPDATE products SET prodsize = '$prodsize' WHERE prod_id = '$editid'";
> $query4 = "UPDATE products SET prodprice = '$prodprice' WHERE prod_id = '$editid'";
> $query5 = "UPDATE products SET prodcat = '$prodcat' WHERE prod_id = '$editid'";
> mysql_query($query1);
> mysql_query($query2);
> mysql_query($query3);
> mysql_query($query4);
> mysql_query($query5);
You don't want to do that in 5 queries if you can do it in 1:
UPDATE products SET prodname='$prodname', proddesc='$proddesc', etc..
WHERE prod_id = '$editid';
--
felix
Please use
BBCode to format your messages in this forum.