Probably Join?!

jensos

Hi!

I have a question regarding a query with searches two tables.
I have a single-site with two tables. In the first table every person has a profil (with postal code an city, etc) and in the second table there are all the contact-ads of the people. The second table just has the nickname of the person, a headline and a text.

Now people should be able to search for a keyword and in a special city, but the city name and the zip-code are not stored in the table with the contact-ads.

My question is: How do I have to build the query, so that it just just shows contact-ads of people how have a special zip-code or a special city in their profil?

I guess it is made with a join, but I have no idea how this should look like...

Thanks for your help!

Jens

amcgrath

Well, you kinda answer your own question... just break it down, and it will come:

You: "How do I have to build the query, so that it just just shows contact-ads..."

SQL: "select * from contact-ads";

You: "...people how have a special zip-code in their profile..."

SQL: "select contact-ads.,users. from contact-ads,users where users.zip-code = '$zip-code'";

You: "...The second table just has the nickname of the person..."

SQL: "select contact-ads.,users. from contact-ads,users where users.zip-code = '$zip-code' and contact-ads.nickname = users.nickname";

There ya go, that should at least get you where you need to go...

jensos

Ah!

This sounds good... I think this should do it. But how do I get the data?

$contact_data = mysql_fetch_object($query)
$user_name = $contact_data -> users.name;

Or is this wrong?
Anyway... I can test the query in some days.. when the rest is done... I hope it works this way...

Thanx & Bye!

jens