Searching multiple tables

[ljschrenk]

Hey Guys,

I think I am just really brain dead this weekend but I could really use some help to point me in the right direction. I am working on a project for a committee that will allow users to search for a specific church based on 7 different criteria.

My problem is, I'm not exactly sure how to narrow down the list based on the information given.

For instance, the user can search based on location, they could pick NW, SW, NE, and/or NW. In addition, they could also search by number of people, 100-300, 300-500, and/or 500+.

All my tables are separate, ie: one table for location, one table for attendance, and one table for each church with properties of locationid, attendanceid.

How do I perform searches when there is more than 1 option selected for each category (location, attendance), and then narrow the choices based on all the options?

I hope I am making this clear, maybe I should eat lunch, that might help. 🙂

Thanks in advance!!
Lisa

[JakesSA]

$sql = " SELECT t1.column, t2.column FROM table t1, table t2
             WHERE  t1.column2 LIKE '%$var%'; 

[Kanataguy179]

table1:

tbl1id
tbl1label

table2:

tbl2id
tbl2label

table3:

tbl3id
tbl3label
tbl3_2id
tbl3_1id

SELECT tbl3id, tbl3label, tbl2id, tbl21id from table3, table2, table1
WHERE table2.tbl2id = table3.tbl3_2id
AND tablee1.tbl1id = table3.tbl3_1id
AND table1.tbl1label = <some value>
AND table2.tbl2label = <somevalue>

I believe this will help you. Anyone plz correct me if I am wrong.

[ljschrenk]

Thank you so much,

Having it layed out like that really helps, I figured I would have to do table joining but you guys confirmed it. I appreciate your help, if anyone has anymore suggestions or insights feel free to let me know! 😃

This at least gets me started. 🙂

Lisa

[Kanataguy179]

Lisa,

Actually that is a method of joinign tables.

🙂

shaun