User Profile

Collapse

Profile Sidebar

Collapse
Kimberly
Kimberly
Last Activity: Jun 28 '11, 12:00 AM
Joined: Jun 27 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Kimberly
    replied to on duplicate key update only null values
    in PHP
    Thanks so much! Seems so simple now, I just COULD NOT get it. Thank you thank you!
    See more | Go to post

      Leave a comment:

    • Kimberly
      started a topic on duplicate key update only null values
      in PHP

      on duplicate key update only null values

      I am relatively new to php and mySQL. I have a database with a user form used to update and create records. I need to allow duplicate key entries to update but I do not want to overwrite existing values in the field. I only want to update the fields that are empty. Here is the code as I have it.
      Code:
      $sql="INSERT INTO Results (a, b, c, d, e, f, g, h, i, j)
VALUES ('$_POST[a]','$_POST[b]','$_POST[c]','$_POST[d]','$_P
      ...
      See more | Go to post
      No activity results to display
      Show More
      Working...