question mod_joodb

But for example, the database structure:
CREATE TABLE IF NOT EXISTS `#__joodb_sample` (
`myid` int(1) NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL,
`value` varchar(10) DEFAULT NULL,
`usefull` enum('Yes','No','Unknonwn') NOT NULL DEFAULT 'Yes',
`picture` varchar(100) DEFAULT NULL,
`short_description` text,
`description` text NOT NULL,
`wikipedia` varchar(254) DEFAULT NULL,
`category` set('Sport','Food','Tool','Creature') NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`state` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`myid`),
KEY `title` (`title`),
KEY `state` (`state`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Table with joodb sample nosense data. Save to remove';
INSERT INTO `#__joodb_sample` (`myid`, `title`, `value`, `usefull`, `picture`, `short_description`, `description`, `wikipedia`, `category`, `date`, `state`) VALUES
(1, 'Cat', '3,45', 'No', 'cat.jpg', 'A very useless domestic cat.', 'The cat (Felis catus), also known as the domestic cat or housecat to distinguish it from other felines and felids, is a small carnivorous mammal that is valued by humans for its companionship and its ability to hunt vermin and household pests. It has been associated with humans for at least 9,500 years and is currently the most popular pet in the world.', 'en.wikipedia.org/wiki/Cat', 'Sport,Food,Creature', '2009-10-27 16:37:49', 1);

Need from the field "Picture" get the filename in module mod_joodb

mikhaelm wrote: Need from the field "Picture" get the filename in module mod_joodb

Don't use the way the example database uses images unless your are a programmer and you know what to do.

Please use the internal image-system which will automatically resize an create a thumbnail.

You did not answer the question

You did not answer the question, I'm not interested resize, interest me how to get filename and output it in a module

mikhaelm wrote: You did not answer the question, I'm not interested resize, interest me how to get filename and output it in a module

Do you want to output the filename or the image?
I gave you all necessary information.

Example
THIS TOPIC IS CLOSED!!!!