0

hi
i have two tables,i want to display the details in startpost and based on the userid i want to display the username
ie i want to print
posttitle,date,name
using single query please help

CREATE TABLE `creuser` (
  `uid` int(11) NOT NULL auto_increment,
  `username` varchar(100) NOT NULL,
    UNIQUE KEY `uid` (`uid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
CREATE TABLE `startpost` (
    `posttitle` varchar(300) NOT NULL,
  `userid` int(50) NOT NULL,
  `dat` datetime NOT NULL,
  PRIMARY KEY  (`postid`),
  UNIQUE KEY `postid` (`postid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ;
2
Contributors
2
Replies
3
Views
9 Years
Discussion Span
Last Post by queenc
0
SELECT startpost.posttitle, startpost.dat, creuser.username FROM startpost INNER JOIN creuser ON startpost.userid = creuser.uid

That will display all the startpost data with the username for the startposts. Specifying a Where clause like below will let you show one startpost record based on its id.

SELECT startpost.posttitle, startpost.dat, creuser.username FROM startpost INNER JOIN creuser ON startpost.userid = creuser.uid WHERE startpost.postid = 1

This is really quite basic and i suggest you read some articles explaining "JOINS" a good one is here w3schools

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.