Jump to content

Need to get some database info sorted


monkeybidz

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.