Query Not Updating

[J0j0]

When A user submits an update it does not error out, it completes the query, but the data does not update.

 $sql = "UPDATE project_forms SET orderentry_notes='$orderentry_notes' AND orderentry_rootcause='$orderentry_rootcause' AND issue_status='$status' WHERE id=$id;";

That is the query

[bubblenut]

<?php
if(mysql_affected_rows($res)==0) {
  echo($sql);
}
?>

Echo the query if no rows were affected. Then you can see what's going wrong 🙂
HTH
Bubble

[J0j0]

Error Msg upon insertion of code :Warning: mysql_affected_rows(): supplied argument is not a valid MySQL-Link resource in c:\inetpub\wwwroot\issuetracking\orderprocess.php on line 78

UPDATE project_forms SET orderentry_notes='' AND orderentry_rootcause='Incorrectly Ordered Customer Information' AND issue_status='Root Cause Found' WHERE id=3;

I'm stumped.

[J0j0]

I replaced the "AND" between the different rows with a comma ","
Now it updates!
Thank's for the help though!