Help with a project

bushwacker2

Hey guys,

New to the whole php/mysql/html bit but here I go. I am doing a project where I want to create a website about paintball guns. I have a MySQL database that has the paintball guns listed by there company then broken down into guns then that goes off to having reviews, prices, description etc...these are all different tables branched off. So its like Company to many guns, with each gun having a table for what I said above.

Anywhom, I want to create a PHP file that can access mysql and then pull each of these items information for a webpage. I am trying to make a wireframed navigation using these. And I plan on using that php file as the link in it.

I know how to pull the information from mysql via PHP, but what I don't get is how I can make one php file that can have multiple IDs that correspond with the guns of each company that i can use as links.

traq

bushwacker2;11028059 wrote:
I know how to pull the information from mysql via PHP, but what I don't get is how I can make one php file that can have multiple IDs that correspond with the guns of each company that i can use as links.

Use a query string.

example.com/paintballguns.php?item=1234

You can use [font=monospace]$_GET['item'][/font] to find the appropriate product info.

bradgrafelman

Appropriate manual page for more info would be: [man]variables.external[/man].

sneakyimp

Chances are you will have lists for people to find what they want -- or perhaps a search.

For a list, you query your database for a list of manufacturers, perhaps? This would let users search for guns by selecting a manufacturer first and then drilling down based on other lists. How to do this would depend on the structure of your database so we'd need to see that to help.

For a search, you might let people type in a search string or you could have some select boxes (e.g., 'rate of fire') but this also depends on your database structure.