<%
	SQL = "Select Top 3 * From Nokturnal_Radio, Nokturnal_Artists, Nokturnal_Radio_Artists Where Nokturnal_Radio.Radio_Id = Nokturnal_Radio_Artists.Radio_Id And Nokturnal_Radio_Artists.Artists_Id = Nokturnal_Artists.Artists_Id Order By Nokturnal_Radio.Radio_Date"
	Set RS = Server.CreateObject("ADODB.RecordSet")
	RS.Open SQL, NokturnalDB
%>

quote:

---

So my question is ... how do I pull the "TOP 1" Category with all of it's products

---

Hi Crazy,
I like your site and radio. Will turn in sometime , what do your dj's spin?
We have a radio schedule too, like every sunday evening pacific time.
Maybe we can hook up and have guest dj's appearances on each other sites.
Our site is still growing and the audience is still small at this time, but it's still great to listen to live tunes.

To get back to your question. Here's a schematic of it.
What I would do is have a category_id field in the products table that points to the category that it belongs too.

Next "select top 1 * category order by date desc"
then cat_id = rs(cat_id)
then "select * from products where cat_id = " & cat_id

Now you have all the products of the latest cateogory. Hope this help

You can probably combined this into a single sql call but it's more complicated that way.

- Alan
www.iamviet.com

Edited by - aznknight on 27 March 2001 14:40:18