Mod_Rewrite with no id? (Title in url)

[starboy]

I want to achieve a link like so:

 

events/title-of-event

 

But not quiet sure how I do that without passing it the id in the mod rewrite..

(ie: events/20/title-of-event)

 

anyone ever run into this problem?

[trq]

You need to change your database queries to search by name instead of id.

[pal_20007]

or just do a switch() php function

 

switch for var %{query_uri)

 

case "cars/";

$id =1

break;

case "computers/";

$id = 2;

break;

 

then select sql

 

[trq]

That would get pretty tedious pretty quickly.

[cags]

You could also use a RewriteMap, and add the routes to the map when you create new categories. As a rule though, I'd agree with thorpe and say just change the db query to search by slug rather than id.

[Boxerman]

Hi,

 

Sorry to hijack this thread but as I found it I might aswell keep this alive rather than make a new thread.

 

My question is like the above.

 

I'm current using news.php?id=1

 

How do I get it to display:

 

News/titlehere

 

My php grabs the I'd and displays it for that, what do I enter in .htaccess to get what I desire?