Jump to content


Photo

Update/delete blob - how to


  • Please log in to reply
1 reply to this topic

#1 jake_ali

jake_ali
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 08 July 2006 - 06:51 PM

Hi, Just wondering if anyone can give me some pointer on how to delete/update BLOB properly. My app stores articles/documents/images in mysql. Inserting files works great, but if I delete a row which has, say a 2mb pdf file, the mysql table size does not decrease (table.MYD). What would be the proper way to delete/update blob column? Is there specific functions that I use? I searched extensively on search engine but no luck finding anything.

Thanks in advance for you help.

-Jake

#2 jake_ali

jake_ali
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 08 July 2006 - 07:29 PM

Another question: I have a lot of php scripts, getting kinda troublesome to manage. So I am storing those scripts in mysql and retrieving by id, so the link would look like http://localhost/con...r.php?id=pageid ..............what should be header() for content-type for these scripts to execute? my browser is interpreting as application/octet-stream and prompting to save the file rather than executing as a regular php page.

Thanks!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users