Re: php mysql blob fields

If insert works and update does not, I would guess it is because you spelled the table name wrong in the update query. Fred Rodrigo Peres <rperes@mac.com> wrote in message news:B82193DA.603D%rperes@mac.com... > Hi, > > I have a table in mysql that stores some images my fields in this table are: > ImageID,Image_Name, Image_Size, Image_Type, Image_Data (this is the blob). > The problem is, when i insert a new image everything goes fine, but I can't > update it!!! Why? > to insert I'm using this > > if($image != "none") { > $image_bd = addslashes(fread(fopen($imagem,"r"),filesize($imagem))); > $sql = "INSERT INTO > images(ImageID,Image_Name,Image_Size,Image_Type,Image_Data) > > VALUES('','$imagem_name','$imagem_size','$imagem_type','$imagem_bd')"; > $query->executa($sql); > } > > and to update: > > if($imagem != 'none') { > $Image_bd = addslashes(fread(fopen($imagem,"r"),filesize($imagem))); > $sql = "UPDATE imagens SET > Image_Name='$imagem_name',Image_Size='$imagem_size',Image_Type='$imagem_type > ',Image_Data='$image_bd' WHERE ImageID='$ImageID'"; > $query->executa($sql); > } > > Why I cant' update?? > > Thank's in advance > > Rodrigo > -- > >