Click to See Complete Forum and Search --> : URL Rewrite and MSQL Query


Pream
10-22-2008, 04:54 PM
What I want to do is make rewrite the URL from the id values 1,2,3
to the names querying the database for the values

if possible I would like to do this in a .htaccess file

I want to keep the efficiency of using short numeric ids(Primary Keys)
I been searching like crazy and it's nowhere to be found

Thank you for your help

chazzy
10-23-2008, 06:35 AM
no, but what you can do (assuming you're using jsp) is something like this:

1. use a url rewrite to translte /path/to/something into somefile.jsp?value=something
2. in somefile.jsp do a query based on name, rather than based on id.
3. live very happy.

Pream
10-23-2008, 11:51 AM
I may have not been clear but I am doing the rewrite for SEO purposes and I want to keep the efficiency in using the id field
I already did a mod rewrite to get static urls

check it out:
www.quantum-wireless.com