The code you have posted should work, perhaps your query is returning 6 rows all containing the same URL - stick some trace into your code and check it.
Aside: you should really be calling mysql_free_result too.
What i am trying to do is display multiple images, but so far i can only get the same image to appear multiple times instead of different images.
How i am doing the pictures is i am storing the url in mysql and the url that is stored takes me to where the pictures are on my host. I can get the first picture to display and display 6 times. But i can not get 6 different pictures to display. I have tried to look up examples but the only examples i have seen is the ones for how to do blob images. So i am wondering how can i get 6 different pictures to display instead of the same picture multiple times doing the pictures that way i am doing it (url way)?
here is what i currently have
<?php
$result = mysql_query("SELECT * FROM
categorypics order by id ");
while($row = mysql_fetch_array($result))
{
$products_image = $row["products_image"];
//products_image is the name of the field in the images table
}
echo ("<img src = ".$products_image." >");
?>
