query

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 426,593 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 1,678 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser: Programming Forums

Thread Tools Display Modes

Views: 423 | Replies: 2 | Solved

•

Join Date: Mar 2008

Posts: 84

Reputation: queenc is an unknown quantity at this point

Rep Power: 0

Solved Threads: 3

queenc

Offline

Junior Poster in Training

query

Apr 21st, 2008

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

Help with Code Tags

(Toggle Plain Text)

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 ;

Help with Code Tags

(Toggle Plain Text)

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 ;

•

Join Date: Apr 2007

Location: Birmingham

Posts: 378

Reputation: Fungus1487 is an unknown quantity at this point

Rep Power: 2

Solved Threads: 37

Fungus1487 Fungus1487 is offline

Offline

Posting Whiz

Re: query

Apr 21st, 2008

Help with Code Tags

(Toggle Plain Text)

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.

Help with Code Tags

(Toggle Plain Text)

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

When Autumn Falls [ http://www.whenautumnfalls.co.uk ] &&
Designdotworks [ http://www.designdotworks.co.uk ] Web / Graphic / Software Design