SQL Statment - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

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.

Itsacon · 09-09-2006, 12:57 PM

What language is the webpage written in? ASP? PHP? C?

MIDNIGHTBANDIT9 · 09-09-2006, 03:46 PM

Sorry I forgot. This is written in ASP.

Itsacon · 09-09-2006, 11:05 PM

Hmm, don't have experience with ASP, so don't know the syntax, but I'll try to explain what you need to do.

the 'request.querystring("playerID")' sounds pretty logical to me, I assume that's the code to request the part from the querystring (GET and POST vars) that's tagged 'playerID'.

Then you need to parse it into the SQL query. Again, I don't know the ASP syntax for string concatenation, but I believe it's the ampersand (&):

Your current code will be something like this:

Code:

SQLquery = "SELECT * FROM mydatabase where playerID = 'player1'";

change it to something like this

Code:

SQLquery = "SELECT * FROM mydatabase where playerID = '" & request.querystring("playerID") & "'";

Again, I'm not proficient in ASP, so I hope this is useful.

Krishnaswamy · 05-03-2007, 05:52 PM

What you need to create is a parameteric query. This can be easily done for mroe than one parameter. When you do this you will supply the paramer at run time. If you want you can also web enable using what are called Data Access Pages.

Try the link , All you wanted to know about MS Access at the following link:
Hodentek

Monikas · 10-19-2007, 02:41 PM

This is helping Nice work

websiterepairguys · 11-17-2007, 02:05 PM

Google for "asp database tutorial" found tons of helpful samples

heres one

Connecting To An Access Database Using ASP