Problem with a loop inside a PHP SQL statement

Question

Here is my code, part of it is working flawlessly while the other isn't.

<?php
$query  = "Select * from Query ORDER BY time DESC";
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
?>

<span class="hotspot" onmouseover="tooltip.show('<center><b><?php echo $row['name'] ?></b></center>');" onmouseout="tooltip.hide();">
<?php
echo "<img src='/" . $row['name'] . ".gif'> ";
}
?>

Now there is like 100+ rows, the second $row['name'] is working fine with the loop, but the first one is using the First rwos result for every result.
Any Solution?

Answer 1

have you tried assigning $row['name'] to a variable then use the variable to build the HTML?

Answer 2

I'm not sure if this matters but you may want to put a semicolon in your first piece of echo code:

<?php echo $row['name']; ?>

Answer 3

I don't spot any obvious errors-- try adding one line code so it echos the $row['name'] earlier in the loop, which might help you understand better what's going on. See below:

<?php
$query  = "Select * from Query ORDER BY time DESC";
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo $row['name']."<br>";      // <-------- ADD THIS LINE
?>

<span class="hotspot" onmouseover="tooltip.show('<center><b><?php echo $row['name'] ?></b></center>');" onmouseout="tooltip.hide();">
<?php
echo "<img src='/" . $row['name'] . ".gif'> ";
}
?>

Answer 4

I found the problem. The end </span> was after the loop.