".$_GET['listorder']." ORDER BY ILIST_ORD LIMIT 1"; $Item_Results = mysql_db_query($dbname, $SQL); $theNum=mysql_numrows($Item_Results); if($theNum==0){ $SQL = "SELECT * FROM itools WHERE ILIST_NO=".$_GET['list']." ORDER BY ILIST_ORD LIMIT 1"; $Item_Results = mysql_db_query($dbname, $SQL) or die("Failed Query of " . $SQL); //do the query } }elseif($_GET['prev']=="true"){ SetToolsDB(); $SQL = "SELECT * FROM itools WHERE ILIST_NO=".$_GET['list']." AND ILIST_ORD<".$_GET['listorder']." ORDER BY ILIST_ORD DESC LIMIT 1"; $Item_Results = mysql_db_query($dbname, $SQL); $theNum=mysql_numrows($Item_Results); if($theNum==0){ SetToolsDB(); $SQL = "SELECT * FROM itools WHERE ILIST_NO=".$_GET['list']." ORDER BY ILIST_ORD DESC LIMIT 1"; $Item_Results = mysql_db_query($dbname, $SQL) or die("Failed Query of " . $SQL); //do the query } } } SetToolsDB(); $SQL = "SELECT INT_LEVEL FROM make_fill WHERE MAKER='".addslashes(mysql_result($Item_Results,0,"MAKER"))."'"; $Maker_Results = mysql_db_query($dbname, $SQL) or die("Failed Query of " . $SQL); //do the query $MakeNum=mysql_numrows($Maker_Results); ?>

Tool List

&list=&prev=true"><<Prev Item
&list=&next=true">Next Item>>
0 and mysql_result($Item_Results,0,"DL_ITEM") <>1){ $ax_codeShort=strtolower(str_ireplace("c","",str_ireplace("l","",mysql_result($Item_Results,0,"NAUCT_CODE")))); SetToolsDB(); $SQL = "SELECT AUCT_NAME1,A_LOTS, SINGLEDATE, AUCT_LOC, AUCT_CITY, AUCT_STATE,SEQ_ORDER FROM auction_n WHERE NFULL_CODE='".mysql_result($Item_Results,0,"NAUCT_CODE")."'"; $Auction = mysql_db_query($dbname, $SQL) or die("Failed Query of " . $SQL); //do the query $AuctionCount=mysql_numrows($Auction); $theimg="auction/graphics/$ax_codeShort/".mysql_result($Item_Results,0,"NTL_IDNO")."_sm.jpg"; $theimglg="auction/graphics/$ax_codeShort/".mysql_result($Item_Results,0,"NTL_IDNO")."_lg.jpg"; }else{ $theimg="tools/graphics/".mysql_result($Item_Results,0,"NTL_IDNO")."_sm.jpg"; $theimglg="tools/graphics/".mysql_result($Item_Results,0,"NTL_IDNO")."_lg.jpg"; } ?>
Click Here for Large Image
0){?> Length: in.
Maker : 0){echo mysql_result($Maker_Results,0,"INT_LEVEL");}?>
Condition:
0){?> U.S. Patent No.:
Patent:
0 and mysql_result($Item_Results,0,"DL_ITEM") <> 1){?> Estimate: $ - $
Price: $
SOLD:
0 and mysql_result($Item_Results,0,"DL_ITEM") <>1 ){ echo mysql_result($Item_Results,0,"AUCT_COMM"); }else{ echo mysql_result($Item_Results,0,"AUCT_COMM"); } ?>
0 and mysql_result($Item_Results,0,"DL_ITEM") <>1){?> alert('Item has been added to your bid sheet.\\nTo view your bid sheet click the \"Bid Sheet\" button at the top of the page.')";}?>
Bid Amount:   "> "> "> ">
alert('Item has been added to your cart\\nTo view your shopping cart click the \"Shopping Cart\" at the top of the page.')";}?> &type=';" class="box">
0 && $AuctionCount>0 and mysql_result($Item_Results,0,"DL_ITEM") <>1){?>

This tool will be sold at public auction on in , .

&list=&prev=true"><<Prev Item
&list=&next=true">Next Item>>