Displaying images in order

[dbones]

I am trying to display 5 images from my folder location alongside the products in my database. How do I display the images in order without looping the data from the database

$query='SELECT * FROM items ORDER BY id';
if ($r=mysql_query($query)){
while($row = mysql_fetch_array($r)){
for($n=1; $n<5; $n++){
print "<p><image src = 'http://diabri.100webspace.net/images/book$n.jpg'> </p>
<p><b>Title: {$row['title']}</b>
<br>Author: {$row['author']}
<br>Price: {$row['price']}</p>";
}
}
}else{
die('<p>Could not retrieve the data because:<br>'.mysql_error()."<br>.
The query was $query.</p>");
}
mysql_close();

[AndyB]

I think we need a much better description of what you are hoping to do.  The description you gave, and the code you provided, aren't making clear just what problem you have.

[jsladek]

best thing to do would be to add a text feild to the database and put the name of the image in it. Then replace this...
[code]print "<p><image src = 'http://diabri.100webspace.net/images/book$n.jpg'> </p>[/code]
With this
[code]print "<p><image src = 'http://diabri.100webspace.net/images/{$row['image']}'> </p>[/code]
Better Approach if you ask me

-John Sladek