Hi,
Well create a database and a table called 'LINKS'
Maybe have columns like:
link_id, link_string , link_display (optional), creation_dt, creation_id, update_dt, update_id
The type of data stored in the column link_display is for example: 'foldera/folderb/file.xls' or 'foldera/folderb/file.html'
If you're going to display the file links as actual 'hyper links' then you can use the link_display column to store what text the hyper-link displays - like - 'Bobs Page' - 'Billing Page' - 'Site Map'
Now you might have an SQL statement like:
$sql = "SELECT * FROM LINKS";
$result_set = mysql_query($sql, $db_link);
if($result_set){
while($row = mysql_fetch_row($result_set)){
//loop through the rows in the table
$row[0] = $link_id; //of no value to the user
$row[1] = $link; // the string that contains folders & file name
$row[2] = $link_display; // what to display
/// now echo or display the links on the web page
echo "<br><a href=\"$link\">$link_display</a>";
}
}else{
echo "There are no links to display or there was an error retrieving your links";
}
It really wasn't clear what you wanted to display exactly. Are the links just hyper links, or do you have a directory on a webserver with let's say MS Word documents. But it really doesn't matter this would work.
Enjoy
