mysql - Copy URL, Remove the '/' and '.php' and paste remaining in place of Column in Php for MySQLdb -

if site is:

www.abc.com/efg.php

then how can automatically paste efg in place of column name (which firstnamee in one)

here coding:

mysql_select_db("blahblah_abcdefgh") or die(mysql_error());    $data = mysql_query("select firstnamee qwerty")  or die(mysql_error());    $result=mysql_result($data); echo $result; ?> 

thanks in advance

one more thing efg existing column in db

if site is:

www.abc.com/efg.php

then efg is

$value = basename(__file__, '.php');  

use please :) cause i'm not going add injection prone query :)