help me create a query

[badai]

i have two tables.

first table got 3 fields:
name, phone, e-mail

phone is primary key

second table got 4 fields:
phone, yahoo id, google id, ICQ#

phone is foreign key that link to first table. there is no primary key in second table. so altogether i have 6 fields in 2 tables (name, phone, e-mail, yahoo id, google id, ICQ#)

i want to search someone from my table with all 6 parameters (not necessarily all, but user have option to search by no parameter, 1, 2, 3, 4, 5, or all 6 parameters from the form), and display their name only in ascending order.

the form have 6 text fields, and a submit button. if user submit the form empty, then i'll just list all the name. now the user would fill up any number of field and i would have to search from both tables.

the condition to use when searching is LIKE (if only 1 table it would be SELECT * FROM TABLE1 WHERE NAME LIKE '%$name%' ORDER BY NAME ASC)

so, now i have 6 parameters and 2 tables. how do i extend this query to include all 6 parameters? can anyone help me write the query?

thanks. i hope i'm clear enough that you guys could understand me.

[olly86]

I'm not going to write the whole thing for you, but to include multiple tables in the query you should use this approach.

SELECT 1.name FROM table1 1, table2 2 WHERE 1.name LIKE "%name%" ORDER BY 1.name ASC.
_________________
Olly

[aprelium]

badai,

We suggest looking for some tutorials on the Web that explain how to use JOIN in SQL (that's what you're asking for).

But to make things easier, you can start with such a query;

[badai]

it's ok. i already solved it. query the first table, put it in an array, filter it, use for loop to query the 2nd table.

done.