[RESOLVED] Update a table from values on a form

[tjbarr]

I am trying to update a table from values on a form.

<?php

$query ="UPDATE tbl_vessel ( inv_no, sv_type, sv_name, par_no ) values ('$inv_no', '$sv_type', '$sv_name','$par_no')";
$result=pg_Exec ($conn, $query);

}
?>

[tjbarr]

Figured it out

<?php

 $query ="UPDATE tbl_vessel SET sv_name='$sv_name' WHERE inv_no='$inv_no'";
 $result=pg_Exec ($conn, $query);   

}
?>