mod_rewrite help needed $20 reward

Sergeant Joined: Feb 21, 2004 Posts: 101

I am probably missing something simple here, BUT how can I achieve the below??

I am looking for a simply solution to automatically change certain variables in to keywords which will display in the url.

For example, instead of:-
http://www.properties-for-sale-in.com/sections-listarticles-2.html
I would like

http://www.properties-for-sale-in.com/Spain/

And, instead of:-
http://www.properties-for-sale-in.com/sections-viewarticle-440.html I would like

http://www.properties-for-sale-in.com/Spain/Benidorm.html

Not sure if the below info is a clue to this, but anyhow…

Code:

# Table structure for table 'nuke_sections'
#

CREATE TABLE nuke_sections (
secid int(11) NOT NULL auto_increment,
secname varchar(40) NOT NULL,
image varchar(50) NOT NULL,
PRIMARY KEY (secid),
KEY secid (secid)
);

#
# Dumping data for table 'nuke_sections'
#

INSERT INTO nuke_sections VALUES ( '1', 'www.properties-for-sale-in.com', '');
INSERT INTO nuke_sections VALUES ( '2', 'Spain', '');
INSERT INTO nuke_sections VALUES ( '3', 'Bulgaria', '');

And…

Code:

INSERT INTO nuke_seccont VALUES ( '414', '2', 'Madrid', '', '4', 'english');

Earlier, I spotted a posting on gt-nextgen > http://www.gt-nextgen.com/ftopicp-2477.html#2477
It seems this site has there links displayed as words as appose to article numbers!!

A working solution that dosen’t involve me having to write 414=Madrid.html and so on and on, in the .htacess would be Great Laughing

^^^^ $20 Reward available ^^^^ - once I have it working, will pm my paypal details so you can request the cash Laughing

Thanks in advance Wink

Mike