Problems with displaying all images from my mysql-db

predator

I have this script here which helps me to fetch one image from the database

<?
require("dbmanager.php");
if($id) {
$query = "select file_data,file_type from bildspel where id=$id";
$result = @($query);
$data = @MYSQL_RESULT($result,0,"file_data");
$type = @MYSQL_RESULT($result,0,"file_type");
Header( "Content-type: $type");
echo $data;

};
?>
<html>
<head>
<title>untitled</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

</html>

if I want to view one image i need to type "up_slideshow.php?id=2" in the browser url field.

But what shall I do in order to display all the images I have in the database table on the page?

website

well, if up_slideshow.php becomes an image you would simply place many <img tags with different $id values on the html page.

predator

well, the thing is that I don't want to do it manually. If I insert a new picture I want that pic to be displayed with all the other pics (and not be forced to add a new image tag in the document).

RedDragon

try this code....:

$query = mysql_query("select file_data,file_type from bildspel");
while($result = mysql_fetch_array($query)) {
echo $data;
}

predator

thanks for your help but it did not do the trick 🙁

website

<? 
require("dbmanager.php"); 
if($id) { 
$query = "select id,file_data,file_type from bildspel"; 
$result = mysql_query($query);
?>
<html> 
<head> 
<title>untitled</title> 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> 
</head> 
<body> 
<?
while ($row = mysql_fetch_assoc($result)) } ?>
<?=$row['data'];?>
<img src="up_slideshow.php?id=<?=$row['id'];?>"><br>
<? } ?>
</body> 
</html>

This is the best I can do, I almost have no clue of what you are trying to achive, if this doesn't work, try explaining better what you want and I'll try to help as I can!