UPDATE problem

dionyssos

Hi all,

I've created a page to look up a certain record and modify it. It all seems to work, no error messages are given, everything goes smoothly. Except for one thing: the mysql table is not actually updated! I'm probably forgetting something but I can't figure out what. Here's a snippet of the code:

$query2 = "UPDATE fotos SET foto_id='$foto_id', foto ='$foto', thumb ='$thumb', bijschrift ='$bijschrift', categorie ='$categorie', trefwoorden ='$trefwoord', datum ='$datum' WHERE foto_id = '$foto_id'";

$result = mysql_query($query2) or die(mysql_error());
echo mysql_errno().": ".mysql_error()."<BR>";

echo "Het record is gewijzigd!";

Any help is very much appreciated!

Thanks in advance

Dionyssos

amcgrath

Check the value being passed as $foto_id. it defintely gonna be there (if its numeric, don't put it in single quotes).
Why are you seting foto_id = $foto_id when oyu're using that in the where clause? That could cause a non update, especially if you are changing the id...

dionyssos

Thanks a lot for your reply! I let the value foto_id be checked before proceeding and it turned out it was not passed. Turned out I had a coding error in the form that was supposed to pass the variables... stupid me. Anyway, the code works now =).
At first I didn't set foto_id, because I don't want the id's changed. I put it there because I thought for a second it might work. I know..... I'm learning!

Thanks!

Dionyssos