Hi,
is there a way to grab the name of the file that has been clicked by a user, strip the extension [.php] and then use that name as a variable?
e.g. the page would be called "london.php" i'd like to strip the ".php" and then use the "london" as a variable to select from a mysql db. like this:
$query = "SELECT * FROM table where area like '%london%' && state = 'uk' order by url desc";
so the "london" could be an echo statment like
$query = "SELECT * FROM table where area like '%<? echo $filename; ?>%' && state = 'uk' order by url desc";
thanks