Hey,

I'm trying to create a database table where users can post small topics similar to twitter. Now another user can reply to a user topic but how would I build the database to interact together. Insert and select post topic.

CREATE TABLE `users_post` (
`id` int(11) NOT NULL auto_increment,
`user_id` bigint(11) NOT NULL,
`username` varchar(20) collate utf8_unicode_ci NOT NULL,
`date` varchar(128) collate utf8_unicode_ci NOT NULL,
`_post` varchar(255) collate utf8_unicode_ci NOT NULL,
`post_id` varchar(128) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=66 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

1. Would I use a post_id to track user certain post. If somebody reply submit post_id and info to another table or use the same table?

2. Create to tables to handle replied posted

3. How would I write simple database query for this.

Hope this make sense.

Thanks...