Get data from db Mysql PHP

Question

Ok, I now introduce the problem, I have 3 tables Company, CompanyName, Project. In Company i have many companies id and projects id, in CompanyName names of all companies, in Project have names of all project.

If you not understand i will give example,

Company: 1, 3; 5, 7; . . .
CompanyName: 1, FirstName; 2 Secondname; 3 Thirdname; . . .
Project: 1, Firstproject; 2, SecondProject; . . .

Result must be: Company name - Project name

FirstName - Third project
FifthName - Seventh project

But I don't know hot to get data from db like in the example Company name - Project name

I never do SQL query with 3 tables.

My bad you not understand the question ;(

See:

Table Company have 2 rows (3 but we need only 2): CompanyID and ProjectId
Table CompanyName have 2 rows: Id and Name
Table Project have 2 rows Id and Name

In Table Company are only numbers for example CompanyID=3 and ProjectId=100

And I dont know, WHEN I HAVE CompanyID=3 and ProjectId=100 get data from CompanyName and Project and answer must be THEcompany3 = TheProject100.

Can you do a query with two tables? Or just don't know the syntax for JOIN at all? — andrewsi
– andrewsi, Commented Jul 11, 2012 at 17:23
I cant do, but I dont dont know good algoritm, what do with data select all 3 rows or something else ;( — Wizard
– Wizard, Commented Jul 11, 2012 at 17:25

andrewsi · Accepted Answer · 2012-07-11 18:58:25Z

2

I think something like this might work:

SELECT 
    companyName, projectName, companyID
FROM
    company c 
INNER JOIN 
    companyName cn ON c.companyID=cn.companyID
INNER JOIN
    project p ON c.companyID=p.companyID

Editted with new query

SELECT 
    cn.name, p.name
FROM
    company c
INNER JOIN 
    companyName cn ON c.companyID=companyName.ID
INNER JOIN
    project p ON c.companyID=project.ID

Is that what you're after?

edited Jul 11, 2012 at 18:58

answered Jul 11, 2012 at 17:27

andrewsi

10.7k132 gold badges37 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Wizard Over a year ago

companyName, projectName is now ROW, this is 3 tables companyName, projectName, company.

andrewsi Over a year ago

I've added companyID to the SELECT statement - is that what you mean?

Wizard Over a year ago

Please look at my first post I edit it, maybe now it will be easier understandable for you ;)

Razvan Over a year ago

And how is this different from my initial answer ?

andrewsi Over a year ago

@Razvan - aside from having the right field names, I believe it's identical to both our previous answers.

benRollag · Accepted Answer · 2012-07-12 05:27:40Z

0

Select cn.companyname, p.projectname 
FROM company c, projects p, companyname cn 
WHERE c.id = p.id AND c.id = cn.id

edited Jul 12, 2012 at 5:27

benRollag

1,2174 gold badges16 silver badges21 bronze badges

answered Jul 11, 2012 at 17:27

Razvan

10.2k6 gold badges41 silver badges51 bronze badges

Collectives™ on Stack Overflow

Get data from db Mysql PHP

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related