View Single Post
  #1 (permalink)  
Old October 4th, 2004, 01:56 PM
surethg surethg is offline
Registered User
 
Join Date: Oct 2004
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default help with single cell output

ok i have a access database that i'm pulling info from,
in the database there are 3 fields; name, location, files.

the last field, "files" contains a path to a file on the server.
what i want to do is make it so that when it displays the third field
from the table that the path name is a hyperlink instead of just
the plain old path location. this is as far as i have gotten with code. any help or links or examples would help a huge ammount.




Code:
<html><head><title>test</title>
<style type="text/css">
th {color: white; background-color: gray; font-family:arial; font-size: 9pt}
td {background-color: #c0c0c0; font-family:arial; font-size: 9pt}
</style>
</head>
<body>


<?php
$odbc_dsn = "phpaccess";
$odbc_userid = "";
$odbc_password = "";

$query ="SELECT * From Table1";

if(!($odbc_db = odbc_connect($odbc_dsn, $odbc_userid, $odbc_password)))
die("not connected");

if(!($odbc_rs = odbc_do($odbc_db, $query)))
die("error");

$num_cols = odbc_num_fields($odbc_rs);
if($num_cols < 1) die("empty");

?>


<table>
<tr>
<?php

for($a = 1; $a <= $num_cols; $a++)
{
?>
<th><b> <?php
echo odbc_field_name($odbc_rs, $a);
?>
</b></th>

<?php
}
?>
</tr>



<?php

while(odbc_fetch_row($odbc_rs)) {

?> <tr> <?php

for($a = 1; $a <= $num_cols; $a++) {

$data = odbc_result($odbc_rs, $a);
echo "<td>$data</td>";

}
?></tr><?php
}
?>

</table>
</body>
</html>