Need to replace 1 item in a table

[sgtpepper]

I am using a form that collects variables and adds the variables to a table. My query looks like this:

$query= "REPLACE INTO featuredlistings (Idf,picture_name
,picture2_name,picture3_name,picture4_name) VALUES ('$Idf','$picture_name','$picture2_name',
'$picture3_name','$picture4_name')";

I am trying to code this so that the following scenerio works.

User goes to form and fills in the info for Idf,picture_name
,picture2_name,picture3_name, and picture4_name.

Later, lets say they decide to change picture3_name. I would like it so that they go back to this same form and input the Idf (which is set as unique) and new data for picture3_name and the table ONLY updates picture3_name. Currently, it replaces picture3_name but also deletes the other picture fields.

Any ideas?

[rIkLuNd]

Not exactly sure as to what it is that you want to accomplish, but if you want to update the data in a row that already exists, then try this:

$query = "UPDATE featuredlistings SET picture_name='{$picture_name}',
picture2_name='{$picture2_name}', picture3_name='{$picture3_name}',
picture4_name='{$picture4_name}' WHERE Idf='{$Idf}'";

[sgtpepper]

I want to use the form to update one field.

For example,

My form has places to enter 4 picture urls....lets say that the user did this yesterday...(they filled out the form and submitted the form. The data got added to the database).

The next day they decide to make a change to one of the picture url's...so, they use the same form. They fill out only the box in the form that represents the Id number and picture2.

I would like the script to replace the url for picture 2 but keep the old data for the rest of the images.

What happens now, is that instead of replacing picture 2 it deletes everything and adds the new value for picture2.

[CrimsonSoul]

Are the values for $picture_name, $picture2_name etc. already set in the script?

If you're only taking in say $picture2_name but using $picture_name etc. in the update predicates but they're not set then this could be why you're losing them after the update.

[HalfaBee]

You will have to do it in 4 updates or create the string using only pics that are changed.

HalfaBee

if( $picture_name != '' ) {
    $query = "UPDATE featuredlistings SET picture_name='{$picture_name}'
    WHERE Idf='{$Idf}'";
    mysql_query($query);
}


// or like this

$query = "UPDATE featuredlistings SET";
if( $picture_name != '' )
    $query .= "picture_name='{$picture_name}' ";

if( $picture2_name != '' )
    $query .= ", picture2_name='{$picture2_name}' ";

.......


$query .= "WHERE Idf='{$Idf}' ";