Display dynamic data based on category

I am trying to display data based on category, I have this code in MySQL

SELECT Vendors.VendorID, VendorsCategories.VendCatID, Vendors.Company, Vendors.Contact, Vendors.Phone, Vendors.Website, VendorsCategories.CatName
FROM Vendors LEFT JOIN VendorsCategories ON Vendors.intCatID = VendorsCategories.VendCatID
ORDER BY VendorsCategories.CatName , Vendors.Company ASC

I want to have a result like the following example

Category #1

vendor 1
vendor 2
vendor 3

Category #2

vendor 1
vendor 2

and so on...

I want to display the Category name once for all items in that category.

I hope someone can help me with this

Thanks in advanced

instead of using a join query for this, you would use a 2 recordsets,

the first recordset will return the categories

the second recordset nested inside the repeat region for the categories will return the items for the current category.

See the following tutorial for details:
http://www.webassist.com/community/tutorials/view_tutorial.php?tid=12

Thank you Jason,

I followed this tutorial yesterday, but today, since you have suggested to take a look at it, I have been following the tutorial over and over again, trying all day, and I can't get it work, my situation is a little different than this tutorial but I am doing few thing wrong for sure.

Here is an image of my page http://screencast.com/t/7eeK2rEDa (div tags and recordsets).

I can separate the categories easily because is just a repeat selection of the category recordset, here is an image of what I get back from the recordset when I do that http://screencast.com/t/KZIMggxO

Then wen I do a repeat selection of the nested div with the info from the Vendors recordset, I get this http://screencast.com/t/nWtkrzM7jNHk

Any help will be really appreciated.

Thank you.

send a copy of the page please so i can see the code.

Thanks Jason

Here is the page attached

can you give some more details on the structure of the 2 tables please?

What I am trying to do is display the vendors information inside of vendinfoContainer that is placed inside of vendCatContainer this last div should be repeated for each category, and display vendors information for the corresponding category inside.

I understand what you are trying to do, but i need to know more about the table structure to be able to give advice.

I misunderstood your question.

This is the Vendor table http://screencast.com/t/fUEeXoNM it has "intCatID" that is a foreign key http://screencast.com/t/GUwsY6RG1Z7 to Vendors_Categories http://screencast.com/t/SOZiqo6X

hope this helps

Thats not giving me all the info i need.

I'll need to troubleshoot directly, see the private message section.