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 ;

Recommended Answers

All 2 Replies

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

thanks a lot

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.