Return Multiple Pictures

john8675309

Here is my code

<html>
<head>
<title>View all banners</title>
</head>
<body>
<table>
<?
$connect = mysql_connect("localhost","username","pass");
$db = mysql_select_db("insurance",$connect)or die (mysql_error());
$sql = "select bin_data,filetype from company";
$result = mysql_query($sql,$connect) or die (mysql_error());
while ($row = mysql_fetch_array($result)) {
//echo "<tr>";
//Header( "Content-type = $row[1]");
//echo "<td>echo $row[0]</td>";
echo "<img src='$row[0]'>";

//echo "</tr>";
//echo "<tr>";
}
?>
</table>
</body>
</html>

I can't seem to make this display multiple images on the screen. it seems to lock up the script and time out. there is only like 4 in the database probably not even a meg!!!

HELP!!

--John

jasonmills58

Um, I'm new at this, but I think that needs to be

echo "<img src=".$row['0'].">";

TTT

can you get even one picture by using

$sql = "select bin_data,filetype from company LIMIT 0,1";

john8675309

I can get a picture, but just a picture. I thought I tried...

echo "<img src='$row[0]'>";

but I have not tried

echo "<img src='.$row[0]'>";

The only problem I see about putting the . on the $row does that make it so I can't make pitures seperate? I need to make a link to another page using an image id. How will this be possible?

--John

leatherback

Hi,

Quick question.. Is it NAMES or DATA you store in the database/ I have no experience with retrieving actual images from the database, but I am pretty suer that what you are doing is not correct!
You need to link to a page which will make the image from the data, I believe.

john8675309

I store all data in the database.

	CREATE TABLE ads
	(
		id varchar(15),
		description varchar(255),
		bin_data LONGBLOB,
		filename varchar(50),
		filesize varchar(50),
		filetype varchar(50),
		link varchar(255),
		shownno integer(5),
		clickcount integer(5),
		unique(id)
	);

I know the pictures work right because I can

<img src="pic.php">

and inside the code I use just a particular query in the pic.php to get the id.

Please help I am ripping my hair out....

--John