|
$tmp ";
}
@$auction_title=mysql_result($r,0,"name");
@$auction_date=mysql_result($r,0,"date_held");
if ($auction_title) {
echo " $auction_title"; echo ""; } ?> |
qry=$qry"; $result=mysql_query($qry); $numrows=mysql_num_rows($result); // brad april mysql_data_seek($result, 0);// reset SQL poiner to the START $showcategory=trim($showcategory); // echo "
Category: " . ereg_replace("," , ", ",$showcategory) . ""; while (substr($showcategory,0,1)==',') { // trim leading comma $showcategory=substr($showcategory,1); } while (substr($showcategory,strlen($showcategory)-1,1)==',') { // trim trailing $showcategory=substr($showcategory,0,strlen($showcategory)-1); } // show this in showresults under the status message and codes link $displayCategory="
" . ereg_replace("," , ", ",$showcategory) . "";
// echo "
$numrows Lots found";
if ($numrows){
// find next cat - cant restriect by sold/unsold dummy
$q1="select lotnumber from $lot_dbname where category='$cat' ";
if ($subcat) $q1 .= "and subcategory='$subcat' ";
if ($subcat2) $q1 .= "and subcategory2='$subcat2' ";
if ($subcat3) $q1 .= "and subcategory3='$subcat3' ";
// $qry .= $andLotnumber ;
$q1 .= " order by lotnumber";
//echo $q1;
$r1=mysql_query($q1);
$n1=mysql_num_rows($r1);
if ($n1){
$prevcat_lot=mysql_result($r1,0,'lotnumber') -1;
$nextcat_lot=mysql_result($r1,$n1-1,'lotnumber') +1 ;
}
} else {
// we might be at the END or an EMPTY CATEGORY in post auction mode
echo "
There are no Lots in this Category.
Please click here to go back to the Unsold Lots page.
\n"; $prevcat_lot=0; $nextcat_lot=0; $LASTLOT+=0; $q1="select lotnumber from $lot_dbname where lotnumber>$MAXLOT "; if ($unsold_only) $q1 .= "and (realised_price='' or realised_price='0') "; $q1 .=" order by lotnumber ASC limit 1 "; // echo $q1; $r1=mysql_query($q1); $n1=mysql_num_rows($r1); if ($n1){ // $prevcat_lot=mysql_result($r1,0,'lotnumber') -1; $nextcat_lot=mysql_result($r1,$n1-1,'lotnumber') +1 ; } if ($nextcat_lot<$LASTLOT) { // if there are NO LOTS set this to jump ahead next time $nextcat_lot=$LASTLOT+1; } } //echo "
LASTLOT=$LASTLOT, prevcat_lot=$prevcat_lot, nextcat_lot=$nextcat_lot"; // $result=mysql_query($qry); } if ($searchtext){ // allow prev / next page links in showresults for search only ? $start=intval($start); $max=intval($max); if ($max==0) { $max=15; // default } $tosearchtext=strtolower($searchtext); /************** now show all lots but with sOLD on soled ones 28/10/2002 if ($auction_finished){ if ($totalresults==0) { //$qry="select * from $lot_dbname where lcase(description) rlike '$tosearchtext' and (realised_price='' or realised_price='0')"; $result=mysql_query($qry); echo mysql_error(); if ($result) $totalresults=mysql_num_rows($result); } } else { } *****************/ if ($totalresults==0){ // only need to do this once for every search then pass it along next time $qry="select * from $lot_dbname where lcase(description) rlike '$tosearchtext' $andLotnumber"; $result=mysql_query($qry); echo mysql_error(); if ($result) $totalresults=mysql_num_rows($result); } $toshowstart=$start+1; if ($totalresults < ($start+$max)) { $toshowtotalresults=$totalresults; } else { $toshowtotalresults= $start+$max; } echo "Found $totalresults lots matching your search word '$tosearchtext'. Showing results $toshowstart to $toshowtotalresults." ; $qry="select * from $lot_dbname where lcase(description) rlike '$tosearchtext' $andLotnumber order by lotnumber ASC limit $start,$max"; // echo "
qry=$qry"; $result=mysql_query($qry); echo mysql_error(); $numrows=mysql_num_rows($result) ; // echo " found $numrows results for search phrase \"$searchtext\""; } if ($searchlot) { $qry="select * from $lot_dbname where lotnumber=$searchlot $andLotnumber"; if ($auction_finished) { // $qry.=" and (realised_price='' or realised_price='0') "; } // echo "
qry=$qry"; $result=mysql_query($qry); echo mysql_error(); $numrows=mysql_num_rows($result); if ($numrows==0) { echo "
Lot Number $searchlot is invalid.
"; } } $inshortlist=0; // not include ("showresults.php3"); if ($showcategory){ echo "