Loop Issue

[thelos999]

I know this sounds like a rookie question, but I have no idea why this is happening. I am working on a page with a lm trying to display a list of articles along with their images. I am using a while loop, and for some reason I only get one article/image. Also, the article/image I am getting is the last one. Why?

Here is my loop:

$sql = mysql_query("SELECT * FROM article");

while($result = mysql_fetch_array($sql)) {
    echo "<img src='$result[photo]' />";
}

Any suggestions? Thanks in advance...

[bradgrafelman]

Just before the loop, add something like:

echo "Number of articles: " . mysql_num_rows() . "<br>\n";

What is the output?

[thelos999]

Sorry for the late reply. It says 2, which is how many articles there are. Given from the example, it shows that here are two images, but one of the images links is broken. Don't know why. I am bringing in the image path exactly the same way as the other image. If I manually enter(even copy and paste) the image path, I get both images.

I DON"T GET IT!