Products appear listed by Letter, not Page No's

[Brewski2k]

Hi,

 

Happy new year. Ok to my dilemma.

 

I have a store with alot of games and movies. So if a customer for exampel click dvd->Action they get all products listed but if they want to get to for instance Titanic they have to click there way to page 100.

So what i would want is at the top where the products start to list to have the alphabet so the customer could just click the letter "T" and they would jump to where the products start with the letter "T" is.

 

I looked around but i havent found any. I asked earlier and i got a reply to a solution but for that i had to use something called allprods.php and i dont want that i just want to add it to the regulare productlisting. My guess its something that should be added in index.php. I would be very appreciated of any help that i could get.

 

/Thanks Peder

[♥Monika in Germany]

Peder, the code I gave you back then was done for the allprods page, but can of course be shifted over to index. You will need to modify your code to work with it, this is not a contribution that will fit your site immediately.

[Brewski2k]

Peder, the code I gave you back then was done for the allprods page, but can of course be shifted over to index. You will need to modify your code to work with it, this is not a contribution that will fit your site immediately.

 

Hi Monica thx for ur help. I'm working on it atm but i dont know where i should put this code...

 

Then I changed the $product_query_raw string to this....

 

 

CODE

 

$products_new_query_raw = "select p.products_releasedate, p.products_id, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id $where order by pd.products_name";

 

reffered to http://www.oscommerce.com/forums/index.php?s=&...st&p=289137

[♥Monika in Germany]

hi Peder, I'm swiiming with deadlines so I have to take a board break, sorry. I hope someone else comes to help you.

[Brewski2k]

Hi Monika,

 

Thx alot i fully understand. Hopfully someone is reading this to and can give me help. We just have to wait.

 

Happy New Years

[Brewski2k]

Hi monika i dont seem to get any help atm i would really appreciate your help.

 

Greets Peder