Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more - View Single Post

MIDNIGHTBANDIT9 · 09-09-2006, 12:27 PM

Hi.

I am now designing a webpage for my local sports team, and I need some help with an SQL statment.
I have a page where users can view the stats of players. All information is stored in an access database, that is connected and working properly. My current SQL statment is:

SELECT * FROM mydatabase where playerID = 'player1'

and that will display 'Player 1s' records. Doing it this way I have to create a page for every player, and I don't want to do that. I want it so that when I type the address:

profiles.asp?playerID=player2, it will display 'Player 2s' records by modifying my SQL statment to : SELECT * FROM mydatabase where playerID = 'player2'

Then when I type: profiles.asp?playerID=player3, it will display 'Player 3s' records by modifying my SQL statment to: SELECT * FROM mydatabase where playerID = 'player3'

How can I do this. I am pretty sure I will have to request.querystring("playerID") but can't figure it out from there.

Any help?

Thank You.

09-09-2006, 12:27 PM	#1 (permalink)
MIDNIGHTBANDIT9 Junior Member Join Date: Aug 2006 Posts: 5	SQL Statment Hi. I am now designing a webpage for my local sports team, and I need some help with an SQL statment. I have a page where users can view the stats of players. All information is stored in an access database, that is connected and working properly. My current SQL statment is: SELECT * FROM mydatabase where playerID = 'player1' and that will display 'Player 1s' records. Doing it this way I have to create a page for every player, and I don't want to do that. I want it so that when I type the address: profiles.asp?playerID=player2, it will display 'Player 2s' records by modifying my SQL statment to : SELECT * FROM mydatabase where playerID = 'player2' Then when I type: profiles.asp?playerID=player3, it will display 'Player 3s' records by modifying my SQL statment to: SELECT * FROM mydatabase where playerID = 'player3' How can I do this. I am pretty sure I will have to request.querystring("playerID") but can't figure it out from there. Any help? Thank You.