197707 basic mysql editor

i need a very basic php script that will let me view, edit and delete entries in this table.

also i need to be able to view and upload a photo for each entry.

the field "photourl" holds the jpg location.

so, basicaly, a very small php mysql editor with photo view and upload ability.

CREATE TABLE `releases` (

`id` int(11) NOT NULL auto_increment,

`date` varchar(20) NOT NULL default '',

`name` varchar(50) NOT NULL default '',

`body` text NOT NULL,

`label` varchar(20) NOT NULL default 'Caned and Able',

`photourl` varchar(100) NOT NULL default '',

`tracks` text NOT NULL,

PRIMARY KEY (`id`),

KEY `name` (`name`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=0 AUTO_INCREMENT=7 ;

INSERT INTO `releases` (`id`, `date`, `name`, `body`, `label`, `photourl`, `tracks`) VALUES (1, '[url removed, login to view]', 'Extreme', '1st UK digital release ', 'Caned and Able', 'pics/[url removed, login to view]', ''),

(4, '[url removed, login to view]', 'Omni present bob', 'This EP is a South African release only', 'Caned and Able', 'pics/[url removed, login to view]', ''),

(2, '[url removed, login to view]', 'London out there', '2nd Single released on CD and vinyl', 'Caned and Able', 'pics/[url removed, login to view]', ''),

(3, '[url removed, login to view]', 'Filthy Remixes', 'This was released on CD and vinyl.', 'Caned and Able', 'pics/[url removed, login to view]', ''),

(5, '[url removed, login to view]', 'Simon Says', '3rd UK release.', 'Caned and Able', 'pics/[url removed, login to view]', ''),

(6, '[url removed, login to view]', 'Rollercoaster', 'keep an eye out ', 'Caned and Able', 'pics/[url removed, login to view]', '<a href="[url removed, login to view]" target="blank">1.Rollercoaster</a><br><a href="[url removed, login to view]" target="blank">[url removed, login to view] B-side</a><br><a href="[url removed, login to view]" target="blank">[url removed, login to view] video</a><br>');

MySQL Odd Jobs PHP

项目ID： #1943928

关于项目