How display a BLOB field contents in a HTML file?
| From: | Sergio Cornejo | Date: | Tue, 19 Mar 2002 01:55:26 +0000 |
| Subject: | How display a BLOB field contents in a HTML file? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-17750@lists.php.net to get a copy of this message | ||
Hi.
I work in a client project that need to show a images of his products in a
HTML file.
I work with MySQL 3.23.47 for windows 98, Apache 1.3.23 for windows and
PHP4.
I insert the images with EMS MySQL Manager (is too easy)
My databese work ok wend i retrive text information like product_ID ,
Product_Name, Maximun amount of product, etc. but i can't show the image of
the product.
The PHP code is:
<html>
<body>
<?
$link = mysql_connect("localhost", "username","password");
mysql_select_db("MyDB", $link);
$result = mysql_query("SELECT * FROM producto", $link);
echo "ID: ".mysql_result($result, 0, "PRO_ID")."<br>";
echo "Nombre: ".mysql_result($result, 0, "PRO_NOMBRE")."<br>";
echo "Cant max :".mysql_result($result, 0,
"PRO_CANTMAX")."<br>";
echo "Cant min :".mysql_result($result, 0,
"PRO_CANTMIN")."<br>";
echo "Foto :".mysql_result($result, 0, "PRO_CANTMIN")."<br>";
?>
</body>
</html>
I know that some is wrong but i don't know what its
Sergio Cornejo