Simplest Solution

Anon

Hey. Ok my mind isn't working right about this problem. W/O making a 6 connections to the database to search 6 different tables I want a quick way to search them for information and display the results. Small example. 2 tables... X and Y. I want to search X and Y to find every entry in there that a field equals 2. Lets say Broker_number. So how can I do this? Then take it and put X,Y,Z... and so on till you get six tables. Is there a simple way of doing this? Thanks!
Chad
www.brokenformula.com

Anon

so you get 6 tables, I dont understand...

but it is simple enough to search several tables at once...

SELECT table_x., table_y., table_z.* FROM table_x, table_y, table_z WHERE table_x.broker_number = 2 or table_y.broker_number = 2 or table_z.broker_number = 2

forgive the basic syntax, but thats the line you want to be looking at.

Go to MySQL.com or the help site for whatever database you are using.

you will find the accurate syntax there, but you may find I am close!

thats if I understood your question correctly!

Regards,
Charlie

Anon

BTW, sounlds like you was asking an SQL related question in a PHP Programming forum.

I was accused of that earlier tonight - hehehe - the responder never realised mine was a PHP not SQL question!

Anyway - hope that helps!

GN, time to sleep - no caffine left!!!

Anon

Cool thanks bud
Chad

Anon

Hey can anyone else shed some light on this subject? Because I looked up the Select statements in MySQL Documentation but it was as helpful as a knife when you are eating jello. I think Charlie is right but can someone give me how to do it?

Tables to use:
bus_op
res
office_building

Thank you so much!
Chad R. Smith

Anon

ok do the following:

make an SQL Dump of your database (REMOVE any confidential info)
make copies of all your php code relevent to that issue.
place them in a zip file
place the zip file on your server
email a link to the file (DO NOT ATTACHE ANY FILES) to support@intelliwebtech.com

I will see if I can create the exact SQL you need for you!

SQL is very tricky, the slightest mistake can leave you thousands if not more dollars off your mark!