hello
i have a database table with a foreign key reference from another table. Which is the Markets table.

I now have a products column. As below

      Market Products descriptions
  Electronics sonyJ70 2003 sony mobile phone
  Electronics Binatone 3000 Binatone toaster
 Computers Dell navasion300 Dell desktops

etc....

PROBLEM:
i created a repeated region on my site. So all Markets would be repeated.
e.g you have

Automotive
Bargains & Sales
Books & Magazines
Clothing, Accessories & Shoes
computers
Electronics
Flowers & Gifts


now i want to be able to select the total number of products from the table and have them inserted into the repeated region of the markets area. to have

Automotive
Accessories, Parts, Tires, More...

Bargains & Sales
Free Shipping, Clothing Bargains, More...

Books & Magazines
New Books, Top Books, Book Releases, More...

Clothing, Accessories & Shoes
Women, Men, Shoes, Handbags, Lingerie, More...

Computers
Laptops, Desktops, Software, PDAs, More...

Electronics
Digital Cameras, TVs, Cell Phones, More...

Flowers & Gifts
Birthday Flowers, Gift Baskets, Roses, More...


SUMMARY

the script above would be database values, with repeated regions such as

market
categories, More....

to give the above results as seen on http://shopping.yahoo.com

How do i go about this ? I am made to understand that i use ASP scripts to loop through the query results to format the page as above

Thank you

:D

Hi there,

Looks like cross-posting this. formatting a classifieds section

You could always continue with your previous post if that is of same topic, rather than posting it as a new thread.

Cheers!

_________________________
- Vijay G
Strive for Perfection