Problem converting urls into dynamic hyperlinks
Thanks IAN for your assistance. I think I am on the right track, but I am new at this and would appreciate a little more assistance please. I am obviously still doing something wrong. The data is pulling up just fine, but the "url" field in the jobs table is displayed only as a url, but not as a link. Currently {rs_job.url} appears beneath the table as a link, but it disappears when I open my browser. Any advice will be much appreciated.
I have created two tables with the following fields:
1. construction
Business_ID
BusinessName
Position
Salary
State
2. jobs
Job_ID
Business_ID
url
My Recordset is: (rs_job)
SELECT construction.Business_ID, construction.BusinessName, construction.Position, construction.State, construction.Salary, jobs.url
FROM construction INNER JOIN jobs ON construction.Business_ID=jobs.Business_ID
My Code is:
<table width="100%" border="1">
<tr class="Leadership_Table_Header">
<td>business</td>
<td>position</td>
<td>salary</td>
<td>state</td>
<td>website</td>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_rs_job['BusinessName']; ?></td>
<td><?php echo $row_rs_job['Position']; ?></td>
<td><?php echo $row_rs_job['Salary']; ?></td>
<td><?php echo $row_rs_job['State']; ?></td>
<td><?php echo $row_rs_job['url']; ?></td>
</tr>
<?php } while ($row_rs_job = mysql_fetch_assoc($rs_job)); ?>
</table>
<a href="<?php echo ($row_rs_job['url']); ?>" target="_Blank"><?php echo ($row_rs_job['url']); ?></a>