Re: getting "Couldn't get file list" error.

You send way too much info, forcinf people to read through all of it, to understand your way of thinking and your problem. Keep it simple. Anyway, I think there is something wrong in here $sql = "SELECT furn_pic"; $sql .= "FROM crost"; $sql .= "WHERE item_num = $item_num"; $result = mysql_query($sql)or die("Couldn't get file list"); Unless I am very much mistaken, PHP does not invent spaces whiel concatenating strings. Insert one space before the words FROM and WHERE, otherwise you will get something like SELECT furn_picFROM crostWHERE item_num = ... Luis Patrick Roane wrote:

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.