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>
help with single cell output
