[Resolved] How to do this ?

sinbad

Hi ,
I have a Mysql table with 11 fields, I also have a PHP script that access the table and display 4 fields according to the user search. It displays the most important fields (company name, category, etc )
I need a way so that a user who wants to know more about a particular company, can click the name of the company and a new window appears displaying all the 11 fields.

Please help.

laserlight

Cant you simply create the link, and then pass the company id and some other name/value pair via the query string?

sinbad

Hi,
there are 1000s of records in the table. Also when a user performs a search the results set is returned as a table.

sinbad

Here is part of the code

<table width="95%" BGCOLOR="#ceefbd" BORDERCOLOR="teal" border="1" cellspacing="0" cellpadding="1">

<tr>
<td>Name</td>
<td>Products</td>
<td>Type</td>
<td>Country</td>

<?php
while ($row = mysql_fetch_array($query)) {
echo "<tr><td>",$row['name'],"</td><td>",$row['products'],"</td><td>", $row['type'],"</td><td>",$row['country'],"</td></tr>";
}

?>
</table>

I want the field labeled : name, to be a hyperlink that trigers a php script.

gufmn

Just create the page you want to show the details in, ie: details.php

Then, have your loop insert a hyper link for each record and include a tag for your company name.

echo "<tr><td><a href details.php?company="$row['name']">"$row['name']"</a>etc.....

Then, in details.php:

$company = $_GET['company'];

run your query using $company and display the results however you want.

sinbad

Thanks laserlight and gufnm.
it worked.