PHP_SELF help

[harkly]

I have a form that pulls info from a database. I want to be able to edit that info and pull the same page up with the new info at the same time. I think I would use the PHP_SELF.

<FORM name='test' method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">

Does anyone know where there is a good example of this process? I can find some but there are no database envolvment which is not that good for me.

[djjjozsi]

you can make a link for the entry for editing ?

on a success update, use the header() to redirect the user to the current update page.

<?php
if ( !empty( $_POST["id"] ) AND !empty( $_POST["update_table"] ) ) {
    $update_field1 = isset( $_POST["field1"] )? "'" . mysql_real_escape_string( $_POST["field1"] ) . "'" :null;
    $update_field2 = isset( $_POST["field2"] )? "'" . mysql_real_escape_string( $_POST["field2"] ) . "'" :null;

$sql_update = "update table SET `field1`=$update_field1,`field2`=$update_field2 WHERE id=" . intval( $_POST["id"] ) ;
$res_update = mysql_query( $sql_update ) ;

if ( mysql_errno() > 0 ) {
    if ( mysql_errno() == 1062 )
        die( "Duplication!!" );
    else
        die( mysql_error() );
} else {
    $url = basename( $_SERVER["PHP_SELF"] ) . "?id=" . intval( $_GET["id"] );
    header( "Location: " . $url );
} 
} //update if form submitted

?>