My SQL Update Syntax

[shamuraq]

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

[revraz]

And echoing $sql displays what?

[fenway]

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!!!

That's impossible... it won't update other fields... there must be another statement somewhere.