php mysql blob fields
| From: | Rodrigo Peres | Date: | Wed, 21 Nov 2001 19:24:42 +0000 |
| Subject: | php mysql blob fields | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-75436@lists.php.net to get a copy of this message | ||
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
--