Getting File name

[swamp]

Hey,

 

I'm querying my mysql database with this:

 

SELECT id, poster, subject, post, post_date, pagename FROM blog WHERE pagename='FILE NAME HERE'"

 

where it says FILE NAME HERE I want it to detect the page name its currently on (eg my-page-01.php) and then call the row on the database depending on what page its on.

 

Any help much appreciated.

 

Thanks

[tibberous]

Do a print_r($_SERVER), one of the elements has something like the page name.

 

I dunno, I'm really tired, do it and you'll see what I mean. It is useful as hell.

[ignace]

SELECT id, poster, subject, post, post_date, pagename FROM blog WHERE pagename='" . basename(__FILE__) . "'"

 

or

 

SELECT id, poster, subject, post, post_date, pagename FROM blog WHERE pagename='" . basename($_SERVER['SCRIPT_NAME']) . "'"

[swamp]

Wicked, that worked - thanks alot. Now how to i remove the file extension so instead of being my-file.php it just says my-file

 

Cheers!