![\"View](\"./images/nophoto.gif\")
"; //handle sort functions print "[ Sort by: "; print " "; if ($sort == "id DESC") {print "Most Recent";} else {print "Most Recent";} print " "; if ($sort == "make ASC") {print "Make";} else {print "Make";} if ($use_city_state == "Y") { print " "; if ($sort == "city") {print "Model";} else {print "Model";} } print " "; if ($sort == "year DESC") {print "Year";} else {print "Year";} print " "; if ($sort == "miles ASC") {print "Km.";} else {print "Km.";} print " "; if ($sort == "price DESC") {print "Price";} else {print "Price";} print " ]
"; //end sort functions $limit_str = "LIMIT ". $cur_page * $listings_per_page .",$listings_per_page"; $query = "$querystring $limit_str"; $result = mysql_query("$query;",$link); print "
| Listing | "; print "Make | "; if ($use_city_state == "Y") {print "Model | ";} print "Year | "; print "Km. | "; print "FOB Price | "; print "Status | "; print "||
| "; if ($use_city_state == "Y") {print " | ";} print " | "; print " | "; print " | "; print " | "; print " | "; print " | ||
| "; if ($use_city_state == "Y") {print " | ";} print " | "; print " | "; print " | "; print " | "; print " | |||
| ";
$count++;
}
if ($count == 0)
{
print " | ";
}
print "";
print "$a_row[make] | "; if ($use_city_state == "Y") {print "$a_row[city], $a_row[model] | ";} print "$a_row[body] $a_row[year] | "; print "$a_row[miles] | "; if ($a_row[price] == 0) { print "ASK"; } else print " | USD $a_row[price] | "; print "$a_row[stereo] | "; print "
| # $a_row[id] | "; if ($use_city_state == "Y") {print "";} print " | "; print " | "; print " | "; print " | Details ... | "; print "|||
| ";} print " | "; print " | "; print " | "; print " | "; print " | "; print " | |||
| ";} print " | "; print " | "; print " | "; print " | "; print " | "; print " | "; print " | ||
| "; print " | "; print " | "; print " | "; print " | "; print " | "; print " |
"; $prevpage = $cur_page-1; $nextpage = $cur_page+1; if ($page_num != 1){print "Previous Page ";} if ($page_num != $total_num_page){print " Next Page ";} } Print "
| Listing : $a_row[title] |
"; Print "
| ";
//is there an image?
//select images connected to a given listing
$count = 0;
$query = "SELECT * FROM tbl_Files WHERE prop_num = $a_row[id] order by description";
$result = mysql_query("$query",$link);
while ($image_row =mysql_fetch_array ($result) )
{
echo "";
echo stripslashes($image_row[description]) . " \n"; echo "
\n"; $count++; } print " "; if ($count == 0) { print "
";
}
else
{
print "Click photos to enlarge "; } Print " | ";
print "
"; //print "$guidestring "; makelisting($querystring, $link, $guidestring, $cur_page, $listings_per_page, $sort); } //print the footer print"\r\n\r\n"; include("./templates/user_bottom.html"); //gots to close the mysql connection mysql_close($link); ?> | ||||||||||||||||||