monkeybidz Posted November 28, 2007 Share Posted November 28, 2007 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"); ?> Link to comment https://forums.phpfreaks.com/topic/79186-need-to-get-some-database-info-sorted/ Share on other sites More sharing options...
deadimp Posted November 28, 2007 Share Posted November 28, 2007 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>"; } Link to comment https://forums.phpfreaks.com/topic/79186-need-to-get-some-database-info-sorted/#findComment-400844 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.