Hey Guys, I need some help with the database i am building. I have a table where I store the path to pictures. Each user can have 5 pictures. On their edit page they have 5 forms each of which you can upload a picture from. Each for hs a hidden field with a unique number 1-5. When the upload happens, I need to check to see if that number exists in the pic_count field, if it does I update it with the new path, if is doesnt i insert the new path. I can not figure how to get this while loop to work. Basically, I select all rows that match the 'type' and 'id' of the user, then i want to compare the pic_count in there to do teh above. Any help would be appreciated.

$res = mysql_query("select * from pics_table where pics_id='form_pic_val' limit 1;") if(mysql_num_rows($res) == 1) { update } else { insert } It's just a guess; how are the tables set up?