tomdchi Posted September 24, 2008 Share Posted September 24, 2008 What I need this to do is present a list of files with a hyperlink to download each. There can be multiple files in the database associated with a userid. When download.php is accessed it is down by http://domain.com/download.php?userid=56 or whatever the user id is. The code I have will only return the first file in the db. Please, can someone help me with this? The tables I have are: id userid name type size content The code I am working with: <?php include("../dbconnect.php"); include("../includes/functions.php"); $userid = $_GET['userid']; $query = "SELECT name, type, size, content FROM upload WHERE userid = '$userid'"; $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; exit; ?> <html> <head> <title>Download File From MySQL</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <?php // Fix for IE7 and SSL header("Pragma: public"); header("Expires: 0"); // set expiration time header("Cache-Control: must-revalidate, post-check=0, pre-check=0, private"); include("../dbconnect.php"); include("../includes/functions.php"); $query = "SELECT userid, 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($userid, $name) = mysql_fetch_array($result)) { ?> <a href="download.php?id=<?=$id;?>"><?=$name;?></a> <br> <?php } } ?> </body> </html> Quote Link to comment Share on other sites More sharing options...
fenway Posted September 29, 2008 Share Posted September 29, 2008 Which query is the problem? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.