posting data in categories

[vividona]

I found this code in google

CREATE TABLE 
`categories` ( `id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL, 
`parent` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
 -- -- Dumping data for table `categories` -- 

INSERT INTO `categories` 
(`id`, `name`, `parent`) VALUES 
(1, 'Web development', 0),
(2, 'Application development', 0), 
(3, 'Linux', 0), (4, 'Misc', 0), 
(5, 'Php', 1), (6, 'Mysql', 1), 
(7, 'Javascript', 1), 
(8, 'CSS', 1), 
(9, 'C plus plus', 2),
 (10, 'wxWidgets', 2), 
(11, 'Tutorials', 3), 
(12, 'My thoughts', 4);

I need to know
how can I used $_POST['submit']
to insert like these random numbers in my database
parent column seem have strange numbers

[cahva]

Parent column is not a strange nor random number. Its hierarchical data.

For example theres the "Web development" which has id 1 and parent 0. Parent 0 means that it is on root level and is not child.

Then theres "Php","Mysql","Javascript" and "CSS" which all has parent set to 1 which means that they are connected to "Web development" (they are children of "Web development").

This kind of hierarchical data is extremely useful as you can create levels and sublevels(or categories and subcategories) as deep as you like. There are other ways to accomplish this but this is one way to do it.

Heres one link that I googled on this subject:
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html