[Resolved] lots of rows... same values

[fuzic]

I have a table which stores the location of images when I upload them, and a site is supposed to display the images. The site displays the proper number of images, but it just inherits the image location from the previous row (so you end up with 15 of the same picture being displayed)
The code is as follows:

$query = "SELECT FROM photographs ORDER BY number DESC";
$result = mysql_query($query);
$num = mysql_numrows($result);
$query2 = "SELECT FROM photographs LIMIT $val2, $val";
$result2 = mysql_query($query2);
$num2 = mysql_numrows($result2);
$i=0;
$location=mysql_result($result2,$i,"location");
$totpage=round(($num/15)+0.5);
$curpage=round(($val/15)+.05);
while ($i < $num2) {
echo
?>
<img src=images/<?php echo $location; ?>>&nbsp&nbsp&nbsp;
<?php
++$i;
}
?>

any suggestions?

[Natty_Dreadlock]

hi, first thing that could cause problems: do not use echo with the <?php ?> tags, when u exit the php mode with ?> everything is outputted, so leave out that echo in your while loop.
the reason for your problem is that $location does not change it's value in the loop so it cannot work - your code should look like this:

<?php
$query = "SELECT * FROM photographs ORDER BY number DESC"; 
$result = mysql_query($query); 
$num = mysql_numrows($result); 
$query2 = "SELECT * FROM photographs LIMIT $val2, $val"; 
$result2 = mysql_query($query2); 
$num2 = mysql_numrows($result2); 
$i=0; 
$totpage=round(($num/15)+0.5); 
$curpage=round(($val/15)+.05); 
while ($i < $num2) {
$location=mysql_fetch_assoc($result2);
?> 
<img src=images/<?php echo $location["location"]; ?>>    

<?php 
++$i; 
} 
?> 

hth

[fuzic]

man, thanks a bunch!
its working great