[Resolved] MySQL Update syntax

[sebconn]

Hi there

I'm reasonably new to the whole MySQL scene,

I can't seem to get my MySQL update code to work, I'm guessing it's a syntax issue:

  $db = mysql_connect("localhost", "NOTTELLING", "NOTTELLING");

  mysql_select_db("moriacps",$db);

  $sql = "UPDATE compnotes SET lu_date = $todaysdate, tname = $name, trole = $trole, tcomment = $trole, trate = $trate WHERE id = $id"; 

  $result = mysql_query($sql);

All the variables are right, and I don't get any PHP errors which makes me think the MySQL code it's the trouble.

cheers,

[cgraz]

  $db = mysql_connect("localhost", "NOTTELLING", "NOTTELLING");

  mysql_select_db("moriacps");

  // added in single quotes
  $sql = "UPDATE compnotes SET lu_date='$todaysdate', tname='$name', trole='$trole', tcomment='$trole', trate='$trate' WHERE id='$id'"; 

  print $sql . "<br>"; // print the query so you can see what it looks like BEFORE it's being executed
  $result = mysql_query($sql) or die(mysql_error()); // use mysql_error() for additional error checking

Cgraz

[sebconn]

excellent!

thanks for the tips