benzeina

great i will give this a try. I asked few people about this. There is one way you can do this in one script which is using base64 encoding the displaying it. or something like that. but its not supported by all browsers.  Not trying to be an expert, just wanted to share as you just did. Thank  you :)

Hi everyone, I've been trying this for two days. I feel hopeless Sad. Basically I managed to load an image to my mysql. the problem is when displaying the image. It returns about 400 lines of  this --->  "x���y
r��{�ΐN
����E<�l>A�fLF
������". here is my image insertion: if ($_POST['Submit']) { if ($_POST['MAX_FILE_SIZE'] >= $_FILES['file']['size']) { //print_r($_FILES); mysql_connect("localhost", "username", "password") or die(mysql_error()); mysql_select_db("Vehicles"); $photo = addslashes(fread(fopen($_FILES['file']['tmp_name'], "r"), $_FILES['file']['size'])); $query = sprintf("INSERT INTO Cars(Picture, FileType) VALUES ('%s', '%s')", $photo, $_FILES['file']['type']); Is there something missing. I do have the 'Picture' field of type BLOB ! and i use this to retrieve it: <img src="<?php echo $result_ar['Picture']; ?>" width="144" height="108" border="0" id="Image1" />[/url][/url]</td> I would really appreciate your help. Thank you so much in advance. Ben

Hi everyone, I've been trying this for two days. I feel hopeless :(. Basically I managed to load an image to my mysql. the problem is when displaying the image. It returns about 400 lines of  this --->  "x���y
r��{�ΐN
����E<�l>A�fLF
������". here is my image insertion: if ($_POST['Submit']) { if ($_POST['MAX_FILE_SIZE'] >= $_FILES['file']['size']) { //print_r($_FILES); mysql_connect("localhost", "username", "password") or die(mysql_error()); mysql_select_db("Vehicles"); $photo = addslashes(fread(fopen($_FILES['file']['tmp_name'], "r"), $_FILES['file']['size'])); $query = sprintf("INSERT INTO Cars(Picture, FileType) VALUES ('%s', '%s')", $photo, $_FILES['file']['type']); Is there something missing. I do have the 'Picture' field of type BLOB ! and i use this to retrieve it: <img src="<?php echo $result_ar['Picture']; ?>" width="144" height="108" border="0" id="Image1" /></a></a></td> I would really appreciate your help. Thank you so much in advance. Ben