Thanks for the help....i really appreciate it =D
I am able to display the data now.
data is purged out in a few line.
Is there a posibility of displaying the data in a table form?
Im trying to manipulate the codes to do so....but instead of havin it work or evoking errors.... the page will come out blank...So far i have done this:
<?
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);
$list= mysql_fetch_array($result);
while ($list = mysql_fetch_array($result)) {
$field1=$content["field1"];
$field2=$content["field2"];
$field2=$content["field3"];
$field2=$content["field4"];
$field2=$content["field5"];
$field2=$content["field6"];
// display recordset data
echo "<table>";
echo "<tr>";
echo "<td>Field1 Name =</td>";
echo "<td>$field1</td>";
echo "</tr><tr>";
echo "<td>Field2 Name =</td>";
echo "<td>$field2</td>";
echo "</tr>";
echo "<td>Field3 Name =</td>";
echo "<td>$field3</td>";
echo "</tr><tr>";
echo "<td>Field4Name =</td>";
echo "<td>$field4</td>";
echo "</tr><tr>";
echo "<td>Field5 Name =</td>";
echo "<td>$field5</td>";
echo "</tr><tr>";
echo "<td>Field6 Name =</td>";
echo "<td>$field6</td>";
echo "</tr><tr>";
echo "</table>";
}
//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>
Looking forward for the experts point ...thanks
27
