HDFilmMaker2112 Posted May 14, 2011 Share Posted May 14, 2011 The following mysql update isn't updating the database. $tbl_name="products"; // Table name 1 $tbl_name2="keywords"; // Table name 2 $product_id=$_POST['product_id']; $product_name=$_POST['product_name']; $product_price=$_POST['product_price']; $product_category=$_POST['product_category']; $product_link=$_POST['product_link']; $product_image=$_POST['product_image']; $product_tag=$_POST['product_tag']; $keywords=$_POST['keyword']; $keywords=explode(",",$keywords); $product_features=$_POST['product_features']; $product_pros=$_POST['product_pros']; $product_cons=$_POST['product_cons']; $product_description=$_POST['product_description']; $product_notes=$_POST['product_notes']; $sql20="UPDATE $tbl_name product_name=$product_name, product_price=$product_price, product_category=$product_category, product_link=$product_link, product_image=$product_image, product_tag=$product_tag, product_features=$product_features, product_pros=$product_pros, product_cons=$product_cons, product_description=$product_description, product_notes=$product_notes WHERE product_id = $product_id"; mysql_query($sql20); Quote Link to comment https://forums.phpfreaks.com/topic/236393-update-not-updating/ Share on other sites More sharing options...
HDFilmMaker2112 Posted May 14, 2011 Author Share Posted May 14, 2011 missed SET in query. Quote Link to comment https://forums.phpfreaks.com/topic/236393-update-not-updating/#findComment-1215406 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.