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]
