I am trying to display a gif file that I've
successfully stored up to mysql. I have 3 short files
that all work to gether to accomplish this task. 

1. get_image.html (no problems w/this one)

2. get_image.php   (I think this one is fine too)

3. crostchair.php   (this one has the problem)

It is with the 3rd file where the problem exists.

Here is a clip from that file:
-----------------------------------------------------
$sql = "SELECT furn_pic";
        $sql .=  "FROM crost"; 
        $sql .=  "WHERE item_num = $item_num";
        $result = mysql_query($sql)or die("Couldn't get file
list"); 
---------------------------------------------------------
At first, I had to rem out my initial 3 lines of code
to even get as far as I did, or I'd get "invalid
modelID specified"
--------------------------------------------------------
<?php
        
        #global $item_num;


    #if(!is_numeric($item_num))

    #die("Invalid modelId specified");
-------------------------------------------------------
In my db table, item_num is an AUTO_INCREMENT primary
key.
---------------------------------------------------------
Here is code for get_image.php:
-------------------------------------------------------
<?php

/*----------------------------------------------------start
of database
connection/selection------------------------------*/

$link = mysql_pconnect( "localhost", "", "" );
    if ( ! $link ) {
                $dberror = mysql_error();
                return false;
        }else {
    print "<h2>Successfully connected to
server</h2>\n\n";
    }

    if ( ! mysql_select_db( "myfiles", $link ) ) {
                $dberror = mysql_error();
            return false;
        }
        mysql_select_db("myfiles");

        $dbQuery = "SELECT item_num, model_id, furn_name ";

    $dbQuery .= "FROM crost ";

    $dbQuery .= "ORDER BY model_id ASC";

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

?>
        
<!------------------------------------------end of
database
connection/selection------------------------------------------>


<!------------------------------------------start of
HTML column
headings------------------------------------------>     
        
        
        
        <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">

Model ID</font></b></td>

<td width="33%" bgcolor="#FF9900" height="21">

<p style="margin-left: 10"><b><font face="Verdana"
size="2" color="#FFFFFF">

Furniture name</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>

<!------------------------------------------end of
HTML column
headings------------------------------------------>     


<!-------------start of HTML table that inludes ID,
name and pic of each piece of furniture
------------------------------------------>     



<?php

//As mentioned above, we will be displaying each file
as a table row. The HTML code above creates this
table.

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["model_id"]; ?>

</font>

</td>



<td width="33%" bgcolor="#FFDCA8" height="21">

<p style="margin-left: 10">

<font face="Verdana" size="1">

<?php echo $row["furn_name"]; ?>

</font>

</td>



<td width="33%" bgcolor="#FFDCA8" height="21">

<p style="margin-left: 10"><font face="Verdana"
size="1">

<a href="crostchair.php?fileId=<?php echo
$row["item_num"]; ?>">

Download now

</a></font>

</td>

</tr>

<?php

}

echo "</table>";

?>

---------------------------------------------------------
here is code for crostchair.php
---------------------------------------------------------
<?php
        
        #global $item_num;


    #if(!is_numeric($item_num))

    #die("Invalid modelId specified");

/*----------------------------------------------------start
of database
connection/selection------------------------------*/


    $link = mysql_pconnect( "localhost", "", "" );
    if ( ! $link ) {
                $dberror = mysql_error();
                return false;
        }else {
    print "<h2>Successfully connected to
server</h2>\n\n";
    }

    if ( ! mysql_select_db( "myfiles", $link ) ) {
                $dberror = mysql_error();
            return false;
        }
        
        $sql = "SELECT furn_pic";
        $sql .=  "FROM crost"; 
        $sql .=  "WHERE item_num = $item_num";
        $result = mysql_query($sql)or die("Couldn't get file
list");
        
    if(mysql_num_rows($result) == 1)
 
/*-----if row returned from our query, we save its
actual data to a variable,
$fileContent.----------------------------------------------*/
     {


     $fileContent = @mysql_result($result, 0,
"furn_pic");



     header("Content-type: $fileType");

     echo $fileContent;

     }
 
     else

     {

     echo "Record doesn't exist.";

     }

        ?>
Any ideas?

=====
Patrick Roane
Web design and development
www.franklin-band.com
Fox River Grove, Il.

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to