Download data from mysgl table

[Boo]

Hello guys,

I am trying to create a web based application using php and mysql that allows users to download data from mysql table. In the download.php script I am using headers and I simply echo() out the data. The client's computer creates the file but the only thing that a user can read is "Resource id #2", which i really dont understand.

Here is the download.php script:

<?php
if(isset($_GET['caseNumber']))
{
// if caseNumber is set then get the file with the id from database

// This is an example of config.php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '**';
$dbname = '**';

// This is an example opendb.php
$conn = mysql_connect($dbhost, $dbuser, $dbpass)
or die ('Error connecting to mysql');
mysql_select_db($dbname);

$caseNumber = $_GET['caseNumber'];

$query = "SELECT case_description, filing_date, charges FROM INDICTMENT, CASE WHERE CASE.caseNo = INDICTMENT.caseNo AND caseNumber = '$caseNumber'";
$result = mysql_query($query)
or die("Error, query failed");

while(list($case_description, $filing_date, $charges) = mysql_fetch_array($result))

header("Pragma: public");
header ("Cache-Control: cache, must-revalidate, post-check=0, pre-check=0");
header("Content-length: . strlen($result)");
header("Content-type: text/plain");
header('Content-Disposition: attachment; filename="Case details.txt"');

echo$result;
}
?>

any idea?

[tomhath]

You should be echoing $case_description, $filing_date, and $charges.

$result contains a value used by php, it doesn't mean anything to you.

[smartguyin]

while fetching data from the mysql table you have used wrong while statement.... i think sooo try this.....

Change this statment
while(list($case_description, $filing_date, $charges) = mysql_fetch_array($result))

Change it to below one... And tell us did it worked for you.....

while ($row = mysql_fetch_assoc($result)) {
echo "<tr>\n";
foreach($row as $value) {
echo "<td>";
echo $value;
echo "</td>\n";
}
echo "</tr>\n";
}

This will place all the select one in column or try this below...

echo "<table>"
while ($row = mysql_fetch_assoc($result)) {
echo "<tr>";
echo "<td>."$row['case_description']."</td>";
echo "</tr>";
echo "<tr>";
echo "<td>."$row['filing_date']."</td>";
echo "</tr>";
echo "<tr>";
echo "<td>."$row['charges']."</td>";
echo "</tr>";
}
echo "</table>";

This will also place the data in systematic format you gotta make changes in it...... Hop this helps you.

Are you creating a website for advocates....

[Boo]

Done.
Thanks a lot.