Posted by sime on 11/15/66 11:26

Hi,

I have a blob field in a mysql database table. I want to copy a blob
from one record to another. I am having trouble transferring the data
via a php variable. Maybe I need to addslashes or convert to Hex or
something. I've tried a few things but can't quite get it. Here is
simplified code.

mysql_select_db($dbname, $connection);

$query = "SELECT blobthing
FROM mytable
WHERE id = 1;";

$results = mysql_query ($query, $connection);
$row = (mysql_fetch_assoc($result));
$varblobthing = $row['blobthing']; //put the blob in a variable

$query = "UPDATE mytable
SET blobthing = ".$varblobthing.",
WHERE id = 2;";

mysql_query ($query, $connection);


I would love any advice I can get. Thanks in advance.
Simon

• Next in forum: Re: update mysql blob with another blob using php
• Prev in forum: Re: Overloaded functions and function pointers in PHP?
• Thread view: update mysql blob with another blob using php

[Reply to this message]