PHP URL Rewriting / .htaccess question

[scm22ri]

Hi Everyone,

 

I'm trying to append another value onto my URL that I'm dynamically inserting via php syntax, I'm having trouble trying to figure it out.

 

I'm trying to append the a "state" onto my URL.

 

In the below URL is my information where I'm pulling my data

http://whatsmyowncarworth.com/auto/display-information.php

 

In the few URLS below is where I'm getting the "city" and appending it to the URL. (my php syntax is below)

http://whatsmyowncarworth.com/auto/Miami

http://whatsmyowncarworth.com/auto/providence

http://whatsmyowncarworth.com/auto/albany

 

What I'm trying to do is this, I want each URL to have a "state" value so I want the URLS to look like this,

http://whatsmyowncarworth.com/auto/albany/new-york

http://whatsmyowncarworth.com/auto/Miami/florida

http://whatsmyowncarworth.com/auto/providence/rhode-island

 

This is my syntax and below that is my .htaccess code. Any help would be great. Thanks everyone!

 

<?php
include('init.php'); // connection to database

// if city exists...
if (isset($_GET['u'])) {
    // decode and replace hyphen with space
    $city = str_replace('-','',urldecode($_GET['u']));
    
    // if value contains only letters, numbers or spaces...
    if ( preg_match('~^[a-z0-9 ]+$~i',$city) ) {
        // select data from database...
        $data = mysql_query("SELECT State, City FROM cars WHERE City='$city'" );
        if (mysql_num_rows($data) > 0) {
            while ($row = mysql_fetch_assoc($data)) {
                                echo $row["City"]; 
			echo $row["State"];
            }
        }
    }
}
?>

 

>>>>>>>>>>>>>>>>>

 

.htaccess

 

RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ /auto/cars.php?u=$1 [NC]

[trq]

What is your question?

[scm22ri]

Hi Thorpe,

 

My mistake. I can sometimes ramble on.

 

My question is this,

 

I want to add the state that's associated with the city in the URL. How would I do that?

 

I want the URLS to look like this. (the below URLS don't work)

http://whatsmyowncarworth.com/auto/albany/new-york

http://whatsmyowncarworth.com/auto/Miami/florida

http://whatsmyowncarworth.com/auto/providence/rhode-island

 

These are currently working.

http://whatsmyowncarworth.com/auto/Miami

http://whatsmyowncarworth.com/auto/providence

http://whatsmyowncarworth.com/auto/albany

 

Thanks