Mod Rewrite Question? .htaccess

[scm22ri]

Hi Everyone,

 

I've figured out how to re write a url correctly to my website. The problem is no content is showing on the page.

 

I want to take the below URL

http://whatsmyowncar...te=rhode island

 

and turn it into this one (I think I've accomplish that but on the below URL, the page is showing no data). I figred my .htacess was a bit off but I'm not sure how. What am I doing wrong here?

http://whatsmyowncar...om/rhode-island

 

 

RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^([^/]*)$ /state.php?s=&u=$1 [L,NC]

[mrMarcus]

Post the query for that page.  Also, show how you're dealing with the url parameters 's' and 'u'.

 

I'm guessing that your query is something like the following:

 

$state = $_GET['state']; // rhode island
$sql = "SELECT * FROM `table` WHERE `state` = '". $state ."'";

 

But now, because of the rewrite, the state is hyphenated and the query is failing.