Hi Guys,
I need some help with the update feature in MySQL. I have a set of tables but i need to update only some values in each row most of the time. NOT the entire row. When i tried:
$sql="UPDATE jjrc SET pbl='$pbl', pa='$pa', noc='$noc', con='$con', cmn='$cmn', ce='$ce', hst='$hst', tp='$tp', fmt='$fmt', lvl='$lvl', sbj='$sbj', nou='$nou', amt='$amt', ctr='$ctr', dti='$dti', di='$di', sub='$sub', fp='$fp', ec='$ec', ac='$ac', app='$app' WHERE id= $pin";
it works fine.
However when i tried:
$sql="UPDATE jjrc SET sub='$sub', fp='$fp', app='$app' WHERE id= $pin";
All other values that i do not want to update went blank after the update!!!
I only need to update `sub`, `fp` and `app` from time to time.
Could there be an extra syntax?
Pls help guys