Hi all,
Can anyone tell me how to best set up an admin page (form) for inserting data into the database structure below?
CREATE TABLE categories (
CatID bigint(21) NOT NULL auto_increment,
CatName varchar(32) NOT NULL default '',
CatParent bigint(21) default NULL,
Info text NOT NULL,
PRIMARY KEY (CatID),
UNIQUE KEY CatID(CatID)
) TYPE=MyISAM;
#
Dumping data for table 'categories'
#
INSERT INTO categories VALUES (1,'Home','','');
INSERT INTO categories VALUES (2,'Art',1,'');
INSERT INTO categories VALUES (3,'Computers',1,'');
INSERT INTO categories VALUES (4,'Religion',1,'');
INSERT INTO categories VALUES (5,'Scupltures',2,'');
INSERT INTO categories VALUES (6,'Paintings',2,'');
INSERT INTO categories VALUES (7,'E-Commerce',3,'');
INSERT INTO categories VALUES (8,'Graphics',3,'');
INSERT INTO categories VALUES (9,'HTML',3,'');
INSERT INTO categories VALUES (10,'Internet',3,'');
INSERT INTO categories VALUES (11,'Perl',3,'');
INSERT INTO categories VALUES (12,'Judaism',4,'');
INSERT INTO categories VALUES (13,'Christianity',4,'Whitefriars College');
INSERT INTO categories VALUES (14,'JavaScript',9,'JavaScript is a browser extension, originally developed by Netscape, used for real-time processing of information on the client\'s browser.');
INSERT INTO categories VALUES (15,'CSS',9,'CSS is generally used in replacement of deprecated <font> tags and such.');