MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Karthikeyan Balasubramanian Date:March 19 2003 1:39pm
Subject:how to display blob data back to text
View as plain text  
Hi,

  I m using the following query

SELECT id, 
       subject, 
       news, 
       date_format(date, '%m/%d/%Y %h:%i %p') AS date, 
       author, 
       link 
    FROM news
    ORDER BY id DESC LIMIT 5

heres my table structure

CREATE TABLE news (                                                       
   id int(10) unsigned DEFAULT '0' NOT NULL auto_increment,               
   subject varchar(50) NOT NULL,                                          
   news blob NOT NULL,                                                    
   date datetime DEFAULT '0000-00-00' NOT NULL,                           
   author varchar(50) NOT NULL,                                           
   link varchar(150),                                                     
   PRIMARY KEY (id)                                                       
  );      

heres the output i get in my web page

3 Test2 [B@1abcd9b 03/19/2003 06:28 PM karthikeyan 
2 Test1 [B@47b35d 03/19/2003 06:28 PM karthikeyan 

Can i tweak the query so that i can display BLOB data properly.

Have a great day.

Karthikeyan.
-- 
  Karthikeyan Balasubramanian
  mysql_karthik@stripped

-- 
http://www.fastmail.fm - IMAP accessible web-mail
Thread
how to display blob data back to textKarthikeyan Balasubramanian19 Mar
  • Re: how to display blob data back to textPaul DuBois19 Mar
    • Re: how to display blob data back to textMark Matthews19 Mar