I have an online store with about 35,000 products in my database and no matter if you are listing all products in a catagory or viewing search results - all products are displayed in alphabetical order.
My problem is that some of my products start with the word "The" or "A" as the title - so they appear in alphabetical order under the letter "T" or "A". How do I get these items to appear in alphabetical order under the second word but still retain "The" or "A" as the first word of the title?
In other words - having "The World" appear alphabetically under "W" and "A Car" appear under "C" but keeping "The" and "A" as the first words.
Any help would be greatly appreciated. I know a fair bit about ASP/mySQL programming but just can't quite figure this one out.
I've been working on a Web site for a business (my first non-personal site) and I want to help my client get the best search engine listing. Because this is my first for-profit site, I'm not sure what I need to do for optimal search engine placement. I've been poking around the Web, and I think I have a good start, but there are a few questions still remaining:
1) What do I need to do in order to actually GET a page listed in a search engine to begin with? Do I contact the search engines somehow, or are the listings somehow updated automatically.
2) I've seen tips that advise putting meta keywords, etc., on EVERY page on the site. However, we want users to only come to the site via the "front door" - the index page. I don't see much reason to put a bunch of keywords on a page that might be the third part of an application process - coming to the site on that page would cause visitors to be confused. If I limited the search engine keywords to just the index page, would that hurt the listing?
I've started using stored procedures but I have a problem. My stored proc works fine but when I want to use it to list results on several pages I get an error. My previous code:
I'm working on a list of members.In my db I have two columns lastName and marriedName lastName is the member name before they got married and legLastName is their lastname after they got married.
Now I need to display theese two columns in alphabetical order in one list. If I for example have theese members: lastName, marriedName Anderson, Johnson Petersson, Svensson Nilsson, Persson Lindgren, Johnson
I want this result: Anderson Johnson (look for Andersson) Johnson(look for Lindgren) Nilsson Persson(look for Nilsson) Petersson Svensson(look for Petersson)
I have an Access Database with only one table (tblBooks) with 5 fields: id, TestNumber, Book, Author, ReadingLevel, PointValue. I would like to have alphabetical listing of the records displayed by hyperlinks on the top of the page like:
<Previous All | A | B | C | ....| Y | Z | Others Next>
Also would like to have only 25 records per page and bottom page numbering. I know this is a newbie question but I haven't being able to figure it out.
Say I have a DB with 10,000 records and using MySQL paging. I want to put a link setup at the top of the page with the alphabet that will pop to the proper page for each of the letters.
So: 1 A B C D...
Click on 1, goes to page 1, click on A goes to page 7, click on B goes to page 10.. so on so forth. how to find the pages either through an SQL subquery or through ASP. I can write code to make it happen, but I'm looking for a solution that will not hamper performance as much as an array dump and search.
I want to create a page that uses a horizontal alphabetical index such as
a b c .....
so when the user clicks on a letter they go to that section listing the manufacturer names beginning with that letter.
My question is that since I am pulling the names from a database, what is the best way to create the sections for each letter? My first thought is a basic and overkill solution creating a record set for each letter. Would I use arrays?
I know I could just create a separate page for each letter to display the corresponding entries. Would rather have one page at this time.
