Parse a url parameter on form

[mrt003003]

Hi there im using dream weaver and ive created a form that can be updated:

 

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
  $updateSQL = sprintf("UPDATE ships SET FleetName=%s, HealthA=%s, HealthB=%s WHERE ShipID=%s",
                       GetSQLValueString($_POST['select'], "text"),
                       GetSQLValueString($_POST['textfield'], "int"),
                       GetSQLValueString($_POST['textfield2'], "int"),
                       GetSQLValueString($_POST['hiddenField'], "int"));

  mysql_select_db($database_swb, $swb);
  $Result1 = mysql_query($updateSQL, $swb) or die(mysql_error());

  $updateGoTo = "fleet.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
    $updateGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $updateGoTo));
}

 

I want to parse a parameter after its updated and directed to another page but i cant seem to get it to work:

 

  $updateGoTo = "fleet.php?recordID=$row_Ship['FleetName']";

 

Please help

 

Thanks

[requinix]

http_build_query is great for this.

$qs = $_GET; // copy everything from the URL
$qs["recordID"] = $row_Ship["FleetName"];

header("Location: fleet.php?" . http_build_query($qs));
exit; // important!

[mrt003003]

Hi there, thanks for the reply.

 

Would this replace part of the existing above code?? If so how does it fit together please??

 

Sorry im fairly new to this.

 

Thank You