sql - PHP redirect to different page after form submit -

here's first bit of form code

 <form action="php/form.php" id="msform" method="post">  <fieldset id="owner_service"> <h2> dog owner or service provider?</h2> <legend>owner_service</legend> <div class="owner_service"> <input type="radio" id="service" name="owner_service" value="service"> <label ="service"><h5>service provider</h5></label> <input type="radio" id="owner" name="owner_service" value="owner"> <label ="owner"><h5>dog owner</h5></label> </div> <input type="button" name="next" class="next action-button" id="next" value="next" /> </fieldset> 

and here's php

  <?php session_start();  $servername = ""; $username = ""; $password = ""; $dbname = "";  // create connection $conn = new mysqli($servername, $username, $password, $dbname); // check connection if ($conn->connect_error) {     die("connection failed: " . $conn->connect_error); }    $sql = "insert pets (owner_service, gender, age, size, location, ideallocation, service) values ('{$_post['owner_service']}', '{$_post['gender']}', '{$_post['age']}', '{$_post['size']}', '$locationcommastring', '{$_post['ideal_location']}', '{$_post['service']}')";    if($conn->query($sql) === true) {     echo "new record created successfully"; } else {     echo "error: " . $sql . "<br>" . $conn->error; }   ?> 

i've got form running, results in database want bring user new page depending on whether clicked 'service provider' or 'dog owner'. have no idea put header because if replace if statement have results won't show in database.

the if statement goes after query execution. similar @laimingl suggested