passing parameters

[GrahamET]

Its 20 ish years since I has did any real programming - dbase and clipper so I need some help :-(

I have a mySQL database -- company name, address, post code (zip), country, phone, web site etc.

I have a php script that creates a table of the companies in a user selected country. The table show company name and post code.

I want to click on the company name and open a page with full company details. The page needs to be filled from the database so how do I pass the company name to the page creation script so i can query the database?

If this is a bit vague just say and I will fill it out a bit. If its obvious and I am being dumb just say and I will do some more reading.

Graham

[edwardsbc]

It is obvious, but it doesn't mean you are dumb. If your data table has a unique ID field pass that, otherwise pass the company name. I will assume the company name is displayed like so:

echo "<td>$company</td>";

You can change it to something like this:

echo "<td><a href=\"details.php?company=$company\">$company</a></td>";

Then in details.php you can retreive this value with $_GET['company'], possible to build your SQL statement:

$sql="SELECT * FROM mytable WHERE company like '{$_GET['company']}'";