Need to get some database info sorted

[monkeybidz]

I need to get:

city_details1 & city_details2 data for each individual row.

 

Here is the code I am currently using which gives me the same result for all rows.

 

<?php

$query = "select id, title, city_details1, city_details2, starts from PHPAUCTIONREVERSE_auctions
        WHERE
        closed='0' AND
        suspended=0 AND
        private='n' OR private='y' AND ";
        $query .= "starts<=".$NOW."
        ORDER BY starts DESC
        LIMIT ".$SETTINGS['lastitemsnumber']";

$result = mysql_query($query);
$row = mysql_fetch_assoc($result);

if ($result)
$num_auction = mysql_num_rows($result);
else
$num_auction = 0;

$i = 0;

$TPL_last_auctions_value = "";
while($i < $num_auction) {
if($bgcolor == "#FFFFFF") {
	$bgcolor = $FONTCOLOR[$SETTINGS['headercolor']];
} else {
	$bgcolor = "#FFFFFF";
}
$title = mysql_result($result,$i,"title");
           $city_details1 = $row['city_details1'];
           $city_details2 = $row['city_details2'];
$id 	 = mysql_result($result,$i,"id");
$date	 = mysql_result($result,$i,"starts");
?>

[deadimp]

It doesn't look like you're iterating $i. You might want to look into for loops for that, or a while loop with automatic result iteration, like mysql_fetch(). Ex:

while ($row=mysql_fetch($res)) {
print_r($row);
echo "<br>";
}