SELECT * FROM posts WHERE thread=$news[id] ORDER BY id LIMIT 1

SELECT posts.*, posts_text.text AS text FROM posts,posts_text WHERE posts.thread=$news[id] AND posts.id=posts_text.id ORDER BY posts.id LIMIT 1

posts

posts_text

# --------------------------------------------------------

#
# Table structure for table `posts`
#

CREATE TABLE `posts` (
  `id` mediumint(8) NOT NULL auto_increment,
  `thread` smallint(5) unsigned NOT NULL default '0',
  `user` smallint(4) unsigned NOT NULL default '0',
  `date` int(10) unsigned NOT NULL default '0',
  `ip` char(32) NOT NULL default '0.0.0.0',
  `num` mediumint(8) NOT NULL default '0',
  `headid` smallint(6) NOT NULL default '0',
  `signid` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `thread` (`thread`),
  KEY `user` (`user`),
  KEY `date` (`date`),
  KEY `ip` (`ip`)
) TYPE=MyISAM PACK_KEYS=1;

# --------------------------------------------------------

#
# Table structure for table `posts_text`
#

CREATE TABLE `posts_text` (
  `pid` mediumint(8) unsigned NOT NULL default '0',
  `headtext` text,
  `text` mediumtext,
  `signtext` text,
  `tagval` text,
  `edited` text,
  PRIMARY KEY  (`pid`)
) TYPE=MyISAM;