URL REwrite with $_GET function

[soryn4u]

i have on a page something like this

 

<?php
$z =  $_GET['city'];


$query = 'SELECT * FROM '.$z.' WHERE ...
.........
?>

 

in my browser my link  appear like this ---> view.php?city=torino&cat=4

 

i want to make a rewrite url 

i want something like this  ------> view/torino/4

--------------------------------> view/oslo/15

--------------------------------> view/milan/1

 

torino - oslo - milan ..represent $_GET['city'];

 

if i put in .httacces

 

RewriteRule ^view/([^/]+)/id/([^/]+)/?$ view.php?city=$1&id=$2 [QSA,L]

 

dosent work :|

 

i make a mistake?

 

 

[Aureole]

if i put in .httacces

 

Unless that was a typo then no it won't work... it's ".htaccess".

[soryn4u]

i put this in .httacces

------------------

 

AddType application/x-httpd-php .php .htm .html
Options +FollowSymLinks

RewriteEngine On
RewriteBase / 


RewriteRule ^view/?$ view.php?city [L]
RewriteRule ^view/(.+)/?$ view.php?city=$1 [QSA]
RewriteRule ^view/([^/]+)/id/([^/]+)/?$ view.php?city=$1&id=$2 [QSA,L]

-------------------

 

my erorr is this

 

Query Faild: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id =' at line 1

 

 

and my php is this

 

<?php
$z =  $_GET['city'];


$query = 'SELECT * FROM '.$z.' WHERE id = '.$_GET['cat'].' ';

?>

 

 

any solutions?

[Aureole]

Try this...

 

<?php
$z = $_GET['city'];

$query = "SELECT * FROM $z WHERE id='{$_GET['cat']}'";

?>

 

Or this...

 

 

<?php
$z = $_GET['city'];

$query = "SELECT * FROM {$z} WHERE id='{$_GET['cat']}'";

?>