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