Any Ideas?

grahamcracker

I have a table in my database for a list of products sold by a company, and each of these products have details associated with it in another table. I want to create a table where all these products are given and when the user clicks on any of them, it takes them to another page with just that products information.(and the user can only select one at a time.
I was thinking of radio buttons or something, but these cant increase or decrease according to the number of products a company has in the table.

Any ideas how i can do this??

Bjom

Answering to your title first: Yes I got plenty ideas, why? (hint: a descriptive title wins)

Use a dropdown list (<select>). You can add any (or is there actually a limit?) number of items to it in a loop within you php code.

Bjom

grahamcracker

There are no limits, a company may have many records,
but i cannot use a dropdown list, as there is some basic info about the product given in the first table.
So here it is,
The first table has : product name, size, dimension, description. given
When the user clicks on one of the products from the first table, it takes them to a table giving them all the records for that product for the models the company has in stock.

Pikachu2000

You could do something with a link in the product listing, to be processed by the script in the target page, such as

//for each product while the table is building from the query result array...
echo( "<a href=\"product_detail.php?product_id=" . $result_array['product_key'] . "\">View Details</a>" );

Then in product_detail.php

//sanitize the input since it could be manipulated by the user
$product_id = mysqli_real_escape_string($dbc, trim($_REQUEST['product_id']));

$query = "SELECT (fields you want to display) FROM table_with_details where product_id = '" . $product_id . "'";
$result = mysqli_query($dbc, $query);
while ( $array = mysqli_fetch_assoc($result) {
     echo( " (build your result display table/spans/divs/whatever) " );
}