davidjmorin Posted November 24, 2007 Share Posted November 24, 2007 how do i add a table to the following script? so that each link is in a row. <? if(isset($_GET['id'])) { include 'config.php'; include 'opendb.php'; $id = $_GET['id']; $query = "SELECT name, type, size, content FROM upload WHERE id = '$id'"; $result = mysql_query($query) or die('Error, query failed'); list($name, $type, $size, $content) = mysql_fetch_array($result); header("Content-Disposition: attachment; filename=$name"); header("Content-length: $size"); header("Content-type: $type"); echo $content; include 'closedb.php'; exit; } ?> <html> <head> <title>Download File From MySQL</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <? include 'config.php'; include 'opendb.php'; $query = "SELECT id, name FROM upload"; $result = mysql_query($query) or die('Error, query failed'); if(mysql_num_rows($result) == 0) { echo "Database is empty <br>"; } else { while(list($id, $name) = mysql_fetch_array($result)) { ?> <a href="download.php?id=<?=$id;?>"><?=$name;?></a> <br> <? } } include 'closedb.php'; ?> </body> </html> [/php Link to comment https://forums.phpfreaks.com/topic/78691-adding-table/ Share on other sites More sharing options...
victor_ar Posted November 24, 2007 Share Posted November 24, 2007 maybe this helps: echo "<table>"; while(list($id, $name) = mysql_fetch_array($result)) { echo "<tr><a href=\"download.php?id=" . $id . "\">" . $name . "</tr>"; } echo "</table>"; Link to comment https://forums.phpfreaks.com/topic/78691-adding-table/#findComment-398272 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.