update record to mysql

[addie]

hello ppl
i need to know how html form and php script post or get works but dont know hot update works getting records from mysql then changes to update ?

[okuto1973]

$db_name='dbname';
$db_user='user';
$db_password='password';

// connessione al DATABASE
$db_conn = mysql_connect("localhost",$db_user,$db_password);
        if (!$db_conn)
                {
                echo "ERRORE !! non riesco a collegarmi al database!";
                exit();
		}

//Now the update
$update="update table_name set field=$field";

$db_query_programmi=mysql_db_query($db_name,$update);

$field is passed from the previous form page

[addie]

hi, thanks for reply
ok i know how mysql_connect works and basic update i just wanna know form for updating and how php script know to update the current record that im working

[okuto1973]

Post some code..........

[addie]

im talking about same code as u wrote, just i wanna know how script recognizes current recored that i update? i dont know that script

[okuto1973]

$db_name='dbname';
$db_user='user';
$db_password='password';

// connessione al DATABASE
$db_conn = mysql_connect("localhost",$db_user,$db_password);
        if (!$db_conn)
                {
                echo "ERRORE !! non riesco a collegarmi al database!";
                exit();
		}

//Now the update
$update="update table_name set field=$field where id=$id";

$db_query_programmi=mysql_db_query($db_name,$update);

$field is passed from the previous form page

If you write in the update ....."where id=$id" you update only element $id where $id is passed from the previous web page.

[addie]

cool this is it thanks

[okuto1973]

Mark this thread as RESOLVE please!