So i realize that right now it wouldn't insert into database because the if statement is wrong anyways. It would work if i change the code to this.
mysqli_query($connection,"insert into product values('','$_POST[pnm]',$_POST[pprice],$_POST[pqty],'$place1','$_POST[pcategory]','$_POST[pdesc]')");
I didn't need to change anything about the string being written differently. As i said it was just a problem with mamp. I think i did some stuff in privileges that didn't allow me to insert the data. Also trust me you don't need to worry about SQL injection as it is not required in the project. We just have to make a simple site that will never be published. Just the main structure is neccessary. So yea I just wanted to know how to make from the the two options that the user is given (vegetarian/meat products) an if statement to seperate between them and place them in different database tables.