I am calling multiple phrases from 2 seperate tables and then I want to combine them. For example
Table 1 : Florida, Georgia, Texas
Table 2 : apples, pears, oranges

Now I want to display the following :
Flordia apples
Florida Pears
Florida Oranges
Georgia apples
Georgia Pears
Georgia Oranges
etc.
etc.

I've got the MX_Looper suite but you need to have another field to link the two together. I don't have that because these terms are being selected dynamically using checkboxes from 150+ phrases in table.
any suggestions ?

I've got the same problem!!

You need to do this in the sql rather than on the page.

In order to pull all results as you want I beleive you can use the Union command in your SQL statement (beena few years since I used it) Do a search on google for Union join and you should find the code you need.

Regards
Vince

Visit my home: www.chez-vince.com

VBScript | ASP | HTML | SQL | Oracle | Hosting