I'm doing my best to learn php & mysql, but I have ran into a problem that I cannot figure out. I have a vchar field called 'path' which stores a file name. I am attempting to call the file name stored in path via a url. When I place my mouse over the link, it does not include the file name. I am lost as to why this is.
Here is the link to my page, also the code is below. Thanks for any help given.
http://www.bassnhat.com/test.php
<?php require_once('Connections/Test.php'); ?>
<?php
mysql_select_db($database_Test, $Test);
$query_Recordset1 = "SELECT Track_Number, Title, Album, Path FROM Tabs";
$Recordset1 = mysql_query($query_Recordset1, $Test) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<html>
<head>
<title>Test</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table border="1">
<tr>
<td>Track_Number</td>
<td>Title</td>
<td>Album</td>
<td>Path</td>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_Recordset1['Track_Number']; ?></td>
<td><?php echo $row_Recordset1['Title']; ?></td>
<td><?php echo $row_Recordset1['Album']; ?></td>
<td><a href="/bassnhat.com/" target="_blank"><?php echo $row_Recordset1['Path']; ?></a></td>
</tr>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>
