Hi All

I use a MySQL DB with my ASP classic web app.

I've been asked if I can create a routine whereby I get a random

number of products (records) from the DB and display these on the

site. Basically every time a visitor hits the home page, they want

the site to display a random selection of say 6 products.

Hi All

I use a MySQL DB with my ASP classic web app.

I've been asked if I can create a routine whereby I get a random number of

products (records) from the DB and display these on the site. Basically

every time a visitor hits the home page, they want the site to display a

random selection of say 6 products.

I have no problems getting the data and displaying it, my problem is

grabbing 6 random records efficiently.

My initial thought was bring back all of the records to a local array (like

I normally do) and then pick 6 random records in VBscript, but if a DB has

12,000 products this is a silly server hit to bring them all back just to

display 6 out of the 12,000.

The products table doesn't have an auto-number field, the unique-ness is

managed by the product's own unique stock code, but this isn't a sequential

number - its alphanum.

Any ideas on how I can get 6 randoms from the DB rather than bringing all

locally?

Thanks

Hi All

I use a MySQL DB with my ASP classic web app.

I've been asked if I can create a routine whereby I get a random number of

products (records) from the DB and display these on the site. Basically

every time a visitor hits the home page, they want the site to display a

random selection of say 6 products.

I have no problems getting the data and displaying it, my problem is

grabbing 6 random records efficiently.

My initial thought was bring back all of the records to a local array

(like

I normally do) and then pick 6 random records in VBscript, but if a DB has

12,000 products this is a silly server hit to bring them all back just to

display 6 out of the 12,000.

The products table doesn't have an auto-number field, the unique-ness is

managed by the product's own unique stock code, but this isn't a

sequential

number - its alphanum.

Any ideas on how I can get 6 randoms from the DB rather than bringing all

locally?

Thanks

Hi All

I use a MySQL DB with my ASP classic web app.

I've been asked if I can create a routine whereby I get a random number of

products (records) from the DB and display these on the site. Basically

every time a visitor hits the home page, they want the site to display a

random selection of say 6 products.

I have no problems getting the data and displaying it, my problem is

grabbing 6 random records efficiently.

My initial thought was bring back all of the records to a local array (like

I normally do) and then pick 6 random records in VBscript, but if a DB has

12,000 products this is a silly server hit to bring them all back just to

display 6 out of the 12,000.

The products table doesn't have an auto-number field, the unique-ness is

managed by the product's own unique stock code, but this isn't a sequential

number - its alphanum.

Any ideas on how I can get 6 randoms from the DB rather than bringing all

locally?

Thanks