(x)D Arrays.... Help!!

[Anon]

Heres what I am doing...

$test = mysql_query("SELECT * FROM main,bank,builder_fin_info,city,company,contacts,contacts_address,contacts_phone,lender,plan_info,properties,properties_address,properties_houses,properties_lots,sale_prices,state,subdiv,tax_info,zip ");

Now I have a bunch of tables in an array and each table has data.. How do I extract the data?? How would this look (ROWS COLUMBS)
The standard loops don't work, how is the array structured ie..

[0][1][2] (TABLES)
[0]
[1]
[2]
[3][0][1][2][3] (DATA)
F
I
E
L
D
S

Need help.....

[Anon]

ok I got no responce yet so, does anyone know if arrays will do more that 2D???

[Anon]

I don't think you can execute the query like that. If you do "SELECT FROM table1, table2, table3" it will return every possible combination of rows from the tables. So if the three tables I mentioned have 20, 40 and 10 rows respectively, the query returns 2040*10 = 8000 rows. Given how many tables you were extracting from, I reckon it returned about a gazillion rows. 😉

Instead, you have to select * from every table, one at a time.