Simple help with my .htaccess file

[twebman84]

I have a page that is designed to query a baseball database and pull the stats for a specific player based on the URL. Here's the code that my question pertains to:

 

//Break URL Up into an array, each element is the text between each /
$urlParts = explode('/', $_SERVER[REQUEST_URI]);

//Extract player code from URL by selecting the last element
$aPlayer = $urlParts[count($urlParts)-1];

//Deal with a trailing slash on the URL
if($aPlayer=='')
$aPlayer = $urlParts[count($urlParts)-2];

//Connect to Database
require('mysql_con.php');

//Query to retrieve bio info for this player
$getPlayerInfo = "SELECT playerID, nameFirst, nameLast, nameGiven, birthMonth, birthDay, birthYear, birthCity,
			  birthState, debutMonth, debutDay, debutYear, bats, throws, height, weight, nameNick,
			  deathMonth, deathDay, deathYear, deathCity, deathState, photo
			  FROM TBP_Master
			  WHERE playerID = '$aPlayer';";

//Run Query
$playerInfo = mysql_query($getPlayerInfo);

 

And so on...

 

The problem is that there apparently needs to be an entry in my .htaccess file to allow this to work.  The URL should end up like this:  http://www.thebaseballpage.com/players/stats/PLAYERID (the variable)

 

'stats' is the name of the file that contains this code.

 

This all worked fine before I lost my old .htaccess file, so I know the code is good.

 

Does anyone know what needs to be in my .htaccess file?

[Ken2k7]

Yeah you need modrewrite. Read up on it.

[RussellReal]

is /players/ an actual directory?

 

in which case you'd want to put this htaccess into the /players/ directory

 

RewriteEngine on
RewriteRule ^stats/(.*)$ stats.php?player=$1

[twebman84]

Yes, 'players' is an actual directory ... I'm going to put an .htaccess file in 'players' with the entry you suggested.  Is that correct?

 

Thanks for your time.

[RussellReal]

yes it is correct