php question +rep

[Trigs]

I have 3 files. a.php, b.php, and c.php. In each file I have require 'lol.php'. In lol.php I want to create a variable with the filename (either a.php, b.php, or c.php, not lol.php). Would I use $_SERVER['PHP_SELF'] or $_SERVER['SCRIPT_NAME'] or what? Or is there no predefined way variable for this?

+rep to those who help.

[Homosexual]

You can use any, although there are differences. Read up on them from here: http://php.about.com/od/learnphp/qt/_SERVER_PHP.htm :)

[MattFr]

basename(__FILE__);

[Trigs]

You can use any, although there are differences. Read up on them from here: http://php.about.com/od/learnphp/qt/_SERVER_PHP.htm :)

Thanks it worked.


basename(__FILE__);
Didn't work. It showed lol.php instead of 1/2/3.php

Also having another problem. I'm getting


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

The code:



$file = htmlspecialchars($_SERVER['SCRIPT_NAME']);
$query = mysql_query(" SELECT * FROM tablename WHERE file = '$file' ");
$count = mysql_num_rows($query);


Database connection was done before the code. I can verify that the database and tables exist. Can't figure it out though.

[Homosexual]

Fazon,

Show me what happens when you use this code instead:



$file = htmlspecialchars($_SERVER['SCRIPT_NAME']);
$query = mysql_query(" SELECT * FROM tablename WHERE file = '$file' ") or die(mysql_error());
$count = mysql_num_rows($query);


:)

[Trigs]

Nevermind, figured it out. I didn't create the table/user. The guy who did doesn't know php/sql so he didn't give the mysql user any permissions.

Thanks for your help though!

[Homosexual]

It's alright, hit me up a PM if you get any other troubles! :)

[Trigs]

Yeah thanks, haven't coded a system in about a year.

[Homosexual]

PHP isn't my strong point, but I help whenever I can (: