TalkPHP - View Single Post - viewing an image from a table in a database

sarmenhb · 02-12-2008, 07:29 AM

first off,

heres the structure of my table, where content is where the image or file will be stored

Code:

-- Table: upload

-- DROP TABLE IF EXISTS `upload`;

CREATE TABLE `upload` (
  `id`       int AUTO_INCREMENT NOT NULL,
  `name`     varchar(30) NOT NULL,
  `type`     varchar(30) NOT NULL,
  `size`     int NOT NULL,
  `content`  mediumblob NOT NULL,
  `ip`       text COMMENT 'ip',
  `title`    text,
  /* Keys */
  PRIMARY KEY (`id`)
) ENGINE = InnoDB;

what im wondering is what kind of code do i type to show the image as a link.

02-12-2008, 07:29 AM	#1 (permalink)
sarmenhb The Addict Join Date: Jan 2008 Location: los angeles Posts: 309 Thanks: 44	viewing an image from a table in a database first off, heres the structure of my table, where content is where the image or file will be stored Code: -- Table: upload -- DROP TABLE IF EXISTS `upload`; CREATE TABLE `upload` ( `id` int AUTO_INCREMENT NOT NULL, `name` varchar(30) NOT NULL, `type` varchar(30) NOT NULL, `size` int NOT NULL, `content` mediumblob NOT NULL, `ip` text COMMENT 'ip', `title` text, /* Keys */ PRIMARY KEY (`id`) ) ENGINE = InnoDB; what im wondering is what kind of code do i type to show the image as a link. __________________ no signature set