add url to sql query column

[hobey19]

i have a database of computers that i have run everest reports on. these everest reports are in .htm format. i am creating a page to view the quick specs, and i would like each row to have a link to the report file. the code i have is this:

PHP Code:


while($row=mysql_fetch_array($result)){
    echo "<tr>";
    echo "<td>" . $row['comp_name'] . "</td>";
    echo "<td>" . $row['op_sys'] . "</td>";
    echo "<td>" . $row['op_sys_sp'] . "</td>";
    echo "<td>" . $row['comp_model'] . "</td>";
    echo "<td>" . $row['cpu_type'] . "</td>";
    echo "<td>" . $row['cpu_clock'] . "</td>";
    echo "<td>" . $row['memory'] . "</td>";
    echo "<td>" . $row['hard_drive_size'] . "</td>";
    echo "<td>" . $row['ip_address'] . "</td>";
    echo "<td>" . $row['optical_drive1'] . "</td>";
    echo "<td>" . $row['optical_drive2'] . "</td>";
    echo "<td>" . $row['anti_virus'] . "</td>";
    echo "<td>" . $row['room_num'] . "</td>";
    echo "<td>" . $row['report_link'] . "</td>";
    echo "</tr>";
}
echo "</table>"; 


what i want is to have it be something like this for report_link(sorry, don't know the structure, hopefully you understand what i am saying):

PHP Code:

<a href="http://domain/com/report/report_link.htm>View Complete Report</a> 


where report_link is the entry in the report_link field. there is no htm in the report_link field, only the name of the file (ie id18000)

any help would be appreciated. if i am not explaining this well enough, let me know

craig

[Force Flow]

I might be reading this too quickly or not quite understanding what you're looking for, but try looking at a PHP get.

http://mydomain.com/report/report_link.php?myid=18000

PHP Code:

$theidwanted = $_GET["myid"]; 


[hobey19]

my buddy figured it out for me. the code he used:

PHP Code:

echo "<td>" . "<a href=\"http://www.xucraig.com/redwood/reports/" . $row['report_link'] . ".htm\"" . "> 
View Report - " . $row['report_link'] . "</a>" . "</td>"; 


thanks Force. i am slowly trying to learn this stuff, so this small project is helping a lot.

craig