images on file extentions... Need help!

[bluewalrus]

Can you post the full code your using to produce that?

[auriaks]

<?php 
include('db_conn.php');

$queryget = mysql_query("SELECT * FROM xxx ORDER BY `date` LIMIT 3") or die("Error with query");
while ($row = mysql_fetch_array($queryget)) 
{ 
    $name = $row['name']; 
    $type = $row['type']; 
    $nick = $row['nick']; 
   $format = $row['format'];
$filename = $row['filename'];
$date = $row['date'];    
   
    
    
    
    echo " 
    <table width='120px';>     
        <tr>
        <td>
        &nbsp;<img src='redirect_upload/$format' width='80px' height='70px' border='0'>
        <font size='0.8' face='Verdana' color='blue'><b>
        Pavadinimas:&nbsp; $name <br>
        Idejo:&nbsp;&nbsp; $nick       <br>                            
        Data:&nbsp;&nbsp;&nbsp; $date  <br>
        Rusis:&nbsp;&nbsp; $type
        </b></font>
        </td>
        </tr>
    </table> 
    ";     
} 
?>

[Nile]

To clarify, your issue is that you want to see:

And not:

[fg123]

Remove all of the <br>'s

[thetestingsite]

Try this:

<?php 
include('db_conn.php');

$queryget = mysql_query("SELECT * FROM xxx ORDER BY `date` LIMIT 3") or die("Error with query");

$count = 0;
?>
<table width="120px">
 <tr>
<?php   
while ($row = mysql_fetch_array($queryget)) { 

/* I am not getting rid of these assigned variables just in case you use them later in the script */
    $name = $row['name']; 
    $type = $row['type']; 
    $nick = $row['nick']; 
    $format = $row['format'];
    $filename = $row['filename'];
    $date = $row['date'];    
?> 
  <td>
   &nbsp;<img src='redirect_upload/<?php echo $row['format'];?>' width='80px' height='70px' border='0'>
    <font size='0.8' face='Verdana' color='blue'><b>
    Pavadinimas:&nbsp; <?php echo $row['name'];?> <br>
    Idejo:&nbsp;&nbsp; <?php echo $row['nick'];?>       <br>                            
    Data:&nbsp;&nbsp;&nbsp; <?php echo $row['date'];?>  <br>
    Rusis:&nbsp;&nbsp; <?php echo $row['type']; ?>
    </b></font>
   </td>
<?php

 echo ($count % 3) ? '</tr><tr>' : '';

 $count++;
} 
?> 
 </tr>
</table>

Change the number in red above to however many images you want to display across. The above is not tested, but should work.

Hope this helps.

[auriaks]

@fg123

<br>'s just manage looking of my image and text, but everything is in while and it will do 3 times. you cant change the way how they will look in webpage by deleting <br>'s

[Nile]

Auriak, please take a look at mine and thetestingsite's posts above.

[auriaks]

it works! THANKS