Basic example matching records

[mrt003003]

Hi there im just trying to understand how to compare and output results in a table. For example lets say i have the following table:

 

Beans

ID

Type

Location

 

And say 3 records:

 

1

Baked

kitchen

 

2

Runners

Garage

 

3

Broad

Kitchen

 

I want to select only the beans that have matching locations and output the Type: Baked, Broad.

 

I'm trying to get my head around how to work this out, if you could nudge me in the right direction that would be excellent.

 

Thank you.

 

 

[xyph]

This is more of a MySQL/Database question.

[phppaper]

$result = mysql_query("SELECT * FROM Beans where Location = 'something' and (Type = 'Baked' or Type = 'Broad')");

 

while($row = mysql_fetch_array($result)){

 

echo $row['ID'] . " " . $row['Type']. " " . $row['Location'];

  echo "<br />";

}

[mrt003003]

In the Select where Location = 'Something' Does that mean i need to manually input the location im looking for???  ]

Like: Select where Location = 'Kitchen'

 

 

Thanks

[mrt003003]

Ive test the example and it doesnt do what i hoped it would. I need something like: Select * Beans WHERE (MATCH)Location.

 

Is this possible?

 

Thanks

[phppaper]

What you mean by match location? match the user input?

[mrt003003]

Not match a user input, but match for the same input where there is more than 1 occurances of it.

 

So if there are 2 kitchens in the location field of the table then it would select only those records.