mysqli - Insert ignore Query -


hi guys trying - when user click submit button insert data database dont know why not inserting.

someone can see error in code (not giving errors) :

 if(isset($_post['submit']))  {     $flowernameid = $_post['reg_flowertype'];     $_session["flowernameid"] = $flowernameid;     $joinquery = mysqli_query($conn,"select c.id country_id,c.name country_name,f.id flower_id, ft.id flowertype_id tbl_countries c join tbl_flower f join tbl_flowertypes ft on ft.name = f.flower_type f.id ='$_session[flowernameid]'");     while($row = $joinquery -> fetch_assoc())     {             mysqli_query($conn,"insert ignore tbl_boostprice (country_id,flowertype_id,flowername_id,boostprice) values(".$row['country_id'].",".$row['flowertype_id'].",".$row['flower_id'].",0)");     }  } 

thank you.


Comments