update query

[praethorian]

Hi all,

 

I have a classic edit.php file, with 8 file fields (named fname1 - fname8).

User already uploaded pictures and he decided to change some of them.

 

This is sql query that update all columns in the table.

$q = "UPDATE photos SET image1=$fname1, image2=$fname2,..., WHERE id = $id";

,

 

but I would like to update only newly submitted pictures and the old ones leave.

$q = "UPDATE photos SET ".if(isset($fname1)){."image1=$fname1".}.", image2=$fname2,..., WHERE id = $id";

 

Guess I can't do it like the above code.

Any help would be most welcome.

 

Cheers Pete

 

 

 

[opalelement]

I would SELECT them form the database, set $img1 = $row['fname1'] etc..., and then do an if statement to see if the image url changed... if it did, then set $img1 = $newimg1. then just upload them all with fname1 = $img1, fname2 = $img2, yadda yadda