/    Sign up×
Community /Pin to ProfileBookmark

Joining Tables

Copy linkTweet thisAlerts:
Oct 11.2007

Can someone please help me? I have five tables with several fields each and values stored within the fields. I want to have a page that displays a list with values taken from one field in each table. How do I join fields from different tables together and display it in one list? I’m assuming a while loop would be needed to display all fields in the table but how do I throw it all together?

Thanks,
Karen

to post a comment
PHP

1 Comments(s) ↴

Copy linkTweet thisAlerts:
@s_b37Oct 11.2007 — you do mean a table in a mysql db right?

you can do this all within your sql query

im not sure what you want exactly, but you can get more information on selecting from multiple tables, joins and unions at http://www.w3schools.com/sql/sql_join.asp

if you post more information (what type of information, etc) i can give you more details
×

Success!

Help @JS_Freak spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 5.5,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,

tipper: @Samric24,
tipped: article
amount: 1000 SATS,
)...