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 <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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 > -- > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
