Error in BLOBBING..

Hi guys,
I'm working on the BLOBBING tutotial.. all working but not the download. The datas are correctly stored in the DB, are shown but when I click on the DOWNLOAD link i got a:

Invalid blobId specified

why?

The ID is present on the DB but...?

Please help.

Could you please post the code thats causing the error.

Thanks

here's the codes...

thanks

---------showfiles.php-----------
<?php
// Database connection variables
$dbServer = ************
$dbDatabase = ************
$dbUser = ************
$dbPass = ************

$sConn = mysql_connect($dbServer, $dbUser, $dbPass)
or die("Couldn't connect to database server");

$dConn = mysql_select_db($dbDatabase, $sConn)
or die("Couldn't connect to database $dbDatabase");

$dbQuery = "SELECT blobId, blobTitle, blobType ";
$dbQuery .= "FROM myBlobs ";
$dbQuery .= "ORDER BY blobTitle ASC";

$result = mysql_query($dbQuery) or die("Couldn't get file list");

?>

<a href="http://www.devarticles.com"><img border="0" src="http://www.devarticles.com/dlogo.gif"></a>

<table border="1" cellpadding="0" cellspacing="0" bordercolor="#111111" width="100%">

<tr>

<td width="34%" bgcolor="#FF9900" height="21">
<p style="margin-left: 10"><b><font size="2" face="Verdana" color="#FFFFFF">
Description</font></b></td>

<td width="33%" bgcolor="#FF9900" height="21">
<p style="margin-left: 10"><b><font face="Verdana" size="2" color="#FFFFFF">
Type</font></b></td>

<td width="33%" bgcolor="#FF9900" height="21">
<p style="margin-left: 10"><b><font face="Verdana" size="2" color="#FFFFFF">
File</font></b></td>

</tr>

<?php
while($row = mysql_fetch_array($result))
{
?>

<tr>
<td width="34%" bgcolor="#FFDCA8" height="21">
<p style="margin-left: 10; margin-right: 10">
<font face="Verdana" size="1">
<?php echo $row["blobTitle"]; ?>
</font>
</td>

<td width="33%" bgcolor="#FFDCA8" height="21">
<p style="margin-left: 10">
<font face="Verdana" size="1">
<?php echo $row["blobType"]; ?>
</font>
</td>

<td width="33%" bgcolor="#FFDCA8" height="21">
<p style="margin-left: 10"><font face="Verdana" size="1">
<a href="downloadfile.php?fileId=<?php echo $row["blobId"]; ?>">
Download now
</a></font>
</td>
</tr>

<?php
}

echo "</table>";
?>
---------------------end----------------


-----------------downloadfile.php-------
<?php

global $blobId;

if(!is_numeric($blobId))
die("Invalid blobId specified");

// Database connection variables
$dbServer = ************
$dbDatabase = ************
$dbUser = ************
$dbPass = ************

$sConn = mysql_connect($dbServer, $dbUser, $dbPass)
or die("Couldn't connect to database server");

$dConn = mysql_select_db($dbDatabase, $sConn)
or die("Couldn't connect to database $dbDatabase");

$dbQuery = "SELECT blobType, blobData ";
$dbQuery .= "FROM myBlobs ";
$dbQuery .= "WHERE blobId = $blobId";

$result = mysql_query($dbQuery) or die("Couldn't get file list");

if(mysql_num_rows($result) == 1)
{
$fileType = @mysql_result($result, 0, "blobType");
$fileContent = @mysql_result($result, 0, "blobData");

header("Content-type: $fileType");
echo $fileContent;
}
else
{
echo "Record doesn't exist.";
}

?>
---------------------end----------------

I always got that error too! Never did figure it out.

Hi changed the variable needed for the SELECT in the downloadfile.php file.

$dbQuery .= "WHERE blobId = $fileId";

and rem the $blobID:

#global $blobId;

#if(!is_numeric($blobId))
#die("Invalid blobId specified");


Now it works but don't know if this will cause any malfunction....

if you guys out there have any news...

bye