Glad that helped.
There's a few different ways to get across this depending on who is coding it and how the backend is setup.
In Example 1 you can do:
The htaccess rule will look like:
RewriteRule ^Ship-to-(.*)/$ /your-php-script.php?school=$1 [QSA,L]
with the page being:
http://www.dormroommovers.com/Ship-to-Arizona-State-University/
So the "Arizona-State-University" will be the search term for your database query, which looks like the way you are currently doing it. Now there are 2 drawbacks to this:
- You are doing a text search in a database which is not as efficient as a numeric,
- Any text string can be created: /Ship-To-Example-text-Arizona-State-University/ will work as well. This is where canonical's really help reduce duplicate problems.
In example 2 we move over to using a numeric value which also has 2 drawback:
The htaccess rule will look like:
RewriteRule ^Ship-to-(.)-(.)/$ /your-php-script.php?school=$2 [QSA,L]
with the page being:
http://www.dormroommovers.com/Ship-to-Arizona-State-University-23/
So the "Arizona-State-University" is just for SEO value, and the value of the item we are looking for in your database query is $2 since it is the second variable (.*) in our URL string or '23'. Using Auto Insert Id in the database table for the schools makes sure that there is only 1 item with that ID and the database will automatically INDEX that column to make it faster for searching.
The drawbacks:
- It adds a level of ugliness to your URLs,
- Any text string can be still be created: /Ship-To-Example-text-Arizona-State-University-23/ will work as well. However, the database will work more efficiently. Canonical's also help here to reduce duplicate problems.
Now, you can also do caching to keep the database from doing additional queries on pages that do not change, or don't change that often.
Other things I would look into to get rid of the duplicate content is;
Can you currently:
- Edit the content and make different pages?
- Change them to individual descriptions per page?
- Add elements like the school colors, pictures of cheerleaders, etc.
- List the dorms,
- Have Google location maps for each
If not, have that stuff worked in. Just changing out the school name is going to cause problems with duplicate content if it is not already.
Let me know if I answered everything.