mich Posted February 10, 2006 Share Posted February 10, 2006 First, thanks for taking a look at my post.actually, i'm quite rookie in PHP MYSQL.currently, i'm having this problem. i cant seem to be able to find any help on displayingthe GIF format image where i stored in the MYSQL database as "mediumblob".I've seen many site that teach me the usage of path. but the website i'm working needs the usage of retrieving directly from DATABASE.here's my script sample :(i've select the details, and other details has been called out just the way i expected)but only the image part give me the problems..)<?php...........$sql = "SELECT T_ID, T_NAME, T_PATH, T_GIF, T_CN_CHAR FROM TIANGAN ORDER BY T_ID ASC;";$result = doSql($sql);$query_data = mysql_fetch_row($result);if($result = doSql($sql)){echo "<table width=100% border=0 >";echo "<td width='15%' height='40' align='left'><b><font face='Arial' size =3>Date</b></td><td width='35%' height='40' align='left' ><b><font face='Arial' size =3>Events</b></td><td width='50%' height='40' align='left'><b><font face ='Arial' size =3>Description</b></td></tr>";while($query_data = mysql_fetch_array($result)){$eventid = $query_data[T_ID];echo "<td valign=top><font face='Arial' size ='2'>$query_data[T_NAME]<br><br></td>";header("Content-Type: image/GIF");echo $query_data[T_GIF];......Please HELP?? unsure.gif Link to comment Share on other sites More sharing options...
real_illusions Posted February 10, 2006 Share Posted February 10, 2006 i dont know the answer to your question..but you should only post one topic..and reply to that topic instead of making 2 identical threads. Link to comment Share on other sites More sharing options...
mich Posted February 11, 2006 Author Share Posted February 11, 2006 sorry for that, but i was nes to this, and i think that my topic title is not expressing the "HELP"...so i just repost another post with another "please help" title... Link to comment Share on other sites More sharing options...
Armed Rebel Posted February 12, 2006 Share Posted February 12, 2006 Can't you just have the url in the DB and then call it into an <img> tag? Link to comment Share on other sites More sharing options...
mich Posted February 13, 2006 Author Share Posted February 13, 2006 thanks so much for replying me..java script:emoticon('')smilieCan you give an exampple of the code? please?not quite familiar yet..with the php script..java script:emoticon('')smilie Can't you just have the url in the DB and then call it into an <img> tag?<{POST_SNAPBACK}> Link to comment Share on other sites More sharing options...
Armed Rebel Posted February 15, 2006 Share Posted February 15, 2006 You'd end up having to change the values to your specifications: $get_img=mysql_fetch_array(mysql_query("SELECT img_url FROM tablename"));// You can split this up into three steps if you want, but it isn't neccesary.echo "<img src='$get_img[img_url]' />"; Providing it is alreayd in your database. Link to comment Share on other sites More sharing options...
mich Posted February 16, 2006 Author Share Posted February 16, 2006 Thanks, Armed Rebel. i'll try it. thank you once more.. You'd end up having to change the values to your specifications:$get_img=mysql_fetch_array(mysql_query("SELECT img_url FROM tablename"));// You can split this up into three steps if you want, but it isn't neccesary.echo "<img src='$get_img[img_url]' />"; Providing it is alreayd in your database. <{POST_SNAPBACK}> Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now