update some columns

pang

Hi,

I want to update a table , but i just want to update some particular columns, but it does not work, so in an update query should i update all the columns in my table?

TheDefender

Post your code, table structure and more details. Otherwise, how can we possibly know where to begin helping you? (You need a WHERE clause in your MySQL to narrow down the particular rows to update, but I can't elaborate on that until you post some more.)

pang

ok , you're right here it is:

i have a Table named Diplom, there are five columns:
noun_diplome, speciality, city, country, num_arrete
so i just want to update a special record in the column num_arrete by the new one named newarrete:

$sqlquery="UPDATE Diplome SET num_arrete='$newarrete' WHERE num_arrete='$ancienarrete'  ";
$result1=mssql_query($sqlquery) or die ("impossible to execute the query");

so i get "impossible to execute the query" does it mean i have to update all the columns

TheDefender

$sqlquery="UPDATE Diplome SET num_arrete='".$newarrete."' WHERE num_arrete='".$ancienarrete."'";

Since you are using double quotes, you need to concatenate the variables into it. Also, try echoing out the variables before this to make sure they have a value associated with them. (And no, you don't have to update all of the columns.)

pang

thanks a lot, it works
but i've always worked in SELECT and INSERT querys like this without concatenations

$sqlquery="SELECT nom_ville FROM Ville,Pays WHERE Pays.nom_pays='$payschoisi' and Pays.code_pays=Ville.code_pays ";

and i've never met problems, why?

TheDefender

Has anything recently changed? PHP upgrade, configuration change, etc?

pang

no , nothing

but now it works without double quote, but i steel have problem with this coding:




$sqlquery2="UPDATE Arrete SET num_arrete='$numarrete',date_arrete='$datearrete',num_bo='$numbo',date_bo='$datebo',page_bo='$pagebo',nom_grade='$grade',nom_departement='$departement' WHERE num_arrete='$ancienarrete' ";
$result2=mssql_query($sqlquery2) or die ("impossible d executer la requete Arrete");

i get impossible d executer la requete Arrete, i've already check by echo that all my variables are not empty