更新表，但制作新的更新表？ [关闭]

Question

$connection=mysql_connect("localhost","root","pass");

mysql_select_db("webdd");

    $a = $_POST['login'];
    $b = $_POST['passe'];
    $c = $_POST['email'];
    $d = $_POST['nom'];
    $e = $_POST['prenom'];
    $f = $_POST['adresse'];
    $g = $_POST['ville'];
    $h = $_POST['tel']; 

mysql_query("UPDATE prestataire SET (login='$a', passe='$b' , email='$c',nom='$d', prenom='$e', adresse='$f', ville='$g', tel='$h' )WHERE login = '$a' )");

mysql_close();

header("location:profile.php"); 

Answer 1

your code

mysql_query("UPDATE prestataire SET (login='$a', passe='$b' , email='$c',nom='$d', prenom='$e', adresse='$f', ville='$g', tel='$h' )WHERE login = '$a' )");

try like this

$sql = "UPDATE prestataire SET (login='$a', passe='$b' , email='$c',nom='$d', prenom='$e', adresse='$f', ville='$g', tel='$h' )";


$request = mysql_query($sql);

better way

 $sql = "UPDATE prestataire SET passe='$b' , email='$c',nom='$d', prenom='$e', adresse='$f', ville='$g', tel='$h' WHERE login='$a'";

You are mentioing login twice in update and second in WHERE - you dont need to mention login two times

if still not then echo your $sql

P.s DUn use mysql it is deprecated