How to display image from mysql

[selvasoft]

please any one help me i want display images from mysql database to my web page...
i have no clear idea about that please help me..
i want script that will upload file and also display files in date vise.
And also i want display my images like my attachment. the images have separate style number so that i want display that number also..
before that tell me how to upload my images with that style number.

[Daiva]

You should have a form which allows user to upload a picture and enter it's code.
Your form should include a upload button and a text field for a code. Your script should take the code entered and the image name, generate the current date and put these three data parts in to the different table columns of your database. (A structure for a table might be: {id, image_name, image_code, upload_date})
Your script for showing images should do a reverse thing - take information from database (sorted according the upload date) and then display it in your page.
I hope it helps a little bit...

[logonchristy]

Just store the uploaded area foler path with image name suffex with date and retrive accordingly...

[logonchristy]

Are u mean upload path as image code...

[muralibobby2015]

put this in your bdy. and make changes according to your database tables

<form name="form2"  method="post"  action="" >

<table align="center" border="0" bordercolor="#000033" width="90%" height="100%"   >
<tr>
<?

$select1=mysql_query("select * from product order by auto_id desc ");
$i=0;
while($fetch=mysql_fetch_array($select1))
{ 
if( $i<4)
{
		
?>
<td><table width="161" border="0" cellspacing="0" cellpadding="0">
                      <tr>
                        <td width="1" bgcolor="#C5DEA1"></td>
                        <td width="159" height="158" valign="top" background="images/box1_midbg.gif"><table width="150" border="0" align="center" cellpadding="0" cellspacing="0">
                          <tr>
                            <td height="19" colspan="2" class="heading1"><img src="images/arrow3.gif" width="9" height="9" /> <?=$fetch[productname]?></td>
                            </tr>
                          <tr>
                            <td width="85" height="114"><img src="admin/productimage/<?=$fetch[productimage]?>" width="79" height="94" /></td>
                           
                            
                          </tr>
                          
                        </table></td>
                        <td width="1" bgcolor="#C5DEA1"></td>
						</tr></table>
						</td>
						<?
						$i++;
						
						}
						if($i==4)
						{
					    echo "<tr>";
					    $i=0;
						 }
						 
						 
}
 
?>
</tr>
 

</table>
</form>