how to copy a row from a table'tipuranibasti'(one field is blob type)to'puranibasti'

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • tabi
    New Member
    • Dec 2011
    • 1

    how to copy a row from a table'tipuranibasti'(one field is blob type)to'puranibasti'

    in my code all field are copied from tipuranibasti to puaranibasti except image(blob one).in table puranibasti it($image field) shows entry as [BLOB - 0B]

    Code:
    <?php
    include ("connect.php");
    $id=@addslashes($_GET['id']);
    $image=@mysql_query("select * from tipuranibasti where  id = $id");
    $image_row=@mysql_fetch_assoc($image);
    
       $name=@$image_row['name'];
       $date=@$image_row['date']; 
       $msg=@$image_row['msg'];
       $image=addslashes(@file_get_contents($image_row['image']));
                  
    			
    if(@mysql_query("insert into puranibasti values('','$name','$date','$msg','$image')"))
    {
        echo "image has been inserted successfully";
    } else
     {
     echo "problem inserting the image";
     }
    ?>
Working...