get users with one city

[sopranolv]

How to get all users with same city

<?php

function quote_smart($value)
{
  $value = htmlspecialchars($value);
  if (get_magic_quotes_gpc())
  {
    $value = stripslashes($value);
  }
  $value = "'" . mysql_real_escape_string($value) . "'";
  return $value;
}

$pilseta = quote_smart($_GET['city']);

$select_u = mysql_query("SELECT * FROM `users` WHERE `city` = $pilseta");
while($u = mysql_fetch_array($select_u)){		

echo $u['username'];?>


<?
}
?>

this script works  x.php?city=new-york   or other city. but i need to show users from the same city from which I am

 

in my profile have city jelgava

 

and I want to make this script show another users with same city get logged in users id by cookies

 

[Barand]

String values need to be inside single quotes in a query

$select_u = mysql_query("SELECT * FROM `users` WHERE `city` = '$pilseta' ");