MySQL Forums
Forum List  »  Newbie

Re: Can't MySQL handle images?!
Posted by: Ace Mace
Date: January 30, 2005 05:14PM

I made the pics field a VARCHAR 255 and I put the path and I already had the autoincrement, etc.. , but it only shows the path in the browser, although I would think BLOB is the way to go but I am too much of a beginer to confirm that.

I also tried to put the tag <img> in the script below, but that just adds a small image icon before the garbage that comes out if I use BLOB.

Here is a part of my script:

while ($row=mysql_fetch_array($result)) {

/////////// Results ///////////////////////
echo("

<tr>
<tr><td colspan=4><img> $row[pics]</td><td></td></tr>
<tr><td></td><td>Item: $row[item]</td></tr>
<tr><td></td><td>Price: $row[price]</td></tr>
<tr><td></td><td>$row[comment]</td></tr>
</tr>

");

Eveything comes out great except for the @#$%^ "pics" field! Heeeeeelp I am stuck! :(

Options: ReplyQuote


Subject
Written By
Posted
January 29, 2005 01:09PM
January 29, 2005 03:09PM
January 29, 2005 08:49PM
Re: Can't MySQL handle images?!
January 30, 2005 05:14PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.