showing images stored in MySQL with same id

rayzun

Has anyone got an idea on how to show multiple images stored in a table, the images have a field which I use to reference them from my webpage
'modelid'

Except after planning the webpage and upload form, I now need to display the image/s, and I use modelid to query the database

id modelid name type size content
42 11 P10000222.jpg image/jpeg 58618 [BLOB - 57.2 KB]
44 11 P1000022.jpg image/jpeg 514344 [BLOB - 502.3 KB]

The display script I have will only show one image:

$query = "SELECT name, type, size, content " .
"FROM upload WHERE modelid = '$id'
LIMIT 0 , 3";
$result = mysql_query($query);
$number = mysql_numrows($result);
{
for ($i=0; $i<$number; $i++) {
$content=mysql_result($result,$i,"content");
$size=mysql_result($result,$i,"size");
$type=mysql_result($result,$i,"type");
echo $content;

To get the image:
print "<img src=\"/formshow.php?id=$id\" width=\"55\">";

fean0r

# Select from Database
$query_items = "SELECT name, type, size, content " . "FROM upload WHERE modelid = '$id' LIMIT 0 , 3";
$items = mysql_query($query_items) or die(mysql_error());
$row_items = mysql_fetch_assoc($items);
# Loop Through the Results
do {
# Display Content
$content=$row_items['content'].$row_items['size'].$row_items['type'];
echo $content."<BR>";
#Display Image
echo "<img src='formshow.php?id=$id' width='55'><BR>"
}
while ($row_items = mysql_fetch_assoc($items));

Try that, it should work.

rayzun

Only one result will display with the above query script.
The table does contain more than one entry (line) per the field 'modelid'.
Thanks for trying

fean0r

Yes I know you have more than 1 line thats why i included do { that loops through the results so if you have 3 entrys with that id it will run 3 times.

Try changing this

$query_items = "SELECT name, type, size, content " . "FROM upload WHERE modelid = '$id'";

Let me know how you get on.

rayzun

Im still only returning one result with the query...

I do understand the extra code is used for loop,
compared to a more basic query where the results will all be output unless limited by using a limit.

Im still searching through the web for similair efforts..

I have found another loop query, however this query does not seem to output anything:

$query1 = "SELECT id FROM upload";
$result1 = mysql_query($query1);
$number1 = mysql_numrows($result1);
// if your image id starts at 1
for( $i=1; $i<$number; $i++ ) {
$query = "SELECT name, type, size, content "
echo $content;

}

My database is not live, but Im not sure even if i can resort the two tables to have the end result.

Thanks for your help\

fean0r

If you are only getting 1 result with that code then you only have 1 line that meets the requirements - I have that code through loads of my php code and they all work 100%.

I doubt know what else to suggest as that should work..

fean0r

btw what is the code on formshow.php

rayzun

I have this code for formshow.php:

$query_items = "SELECT name, type, size, content " . "FROM upload WHERE modelid = '$id'";
$items = mysql_query($query_items) or die(mysql_error());
$row_items = mysql_fetch_assoc($items);
do {
$content=$row_items['content'].$row_items['size'].$row_items['type'];
echo $content."<BR>";
}
while ($row_items = mysql_fetch_assoc($items));

As I understand so far, image is stored in MySQL as binary in a blob field, this page downloads and displays it properly...

The page to show the image by query downloads the page formshow.php
<img src='formshow.php?id=$id'>

the existing problem is how the page downloads the image from the database, how does it download multiple blobs and seperate them into seperate images???