\r\n"; echo "\r\n"; $queryvariable = $_GET['queryvariable']; if (isset($_POST['searchstring'])) { $searchstring=$_POST['searchstring'];} else {$searchstring="";} if ($queryvariable !="") {$searchstring=$queryvariable;} $connid = mysql_connect ('localhost' , 'rastrono' , 'sinhosejar'); mysql_select_db ("rastrono_numbers"); $query = "SELECT Low, aname, fullname, ordinal FROM cardtable WHERE Low ='".$searchstring."' AND ordinal != ''"; $result=mysql_query($query); while($row = mysql_fetch_array($result)){ $titlename = $row['Low']; } mysql_close ($connid); echo ""; If ($searchstring=="") {echo "Beckett Low Breakdown Redirect\r\n"; } else { IF ($titlename =="0.00") {echo "Cards Unpriced by Beckett at Astroland"; } else { echo "Cards Worth ".$titlename." Beckett Low at Astroland\r\n"; }} echo "
\r\n"; echo "
\r\n"; echo "
\r\n"; echo "\r\n"; $htmlcounter=0; if ($searchstring && $searchstring!="") // perform search only if a string was entered. { $connid = mysql_connect ('localhost' , 'rastrono' , 'sinhosejar'); mysql_select_db ("rastrono_numbers"); $query = "Low = '$searchstring' AND trim(fullname) != '^' ORDER by fullname"; $query = "SELECT Low, firstname, lastname, aname, fullname, htmlpage FROM cardtable WHERE ".$query; $result = mysql_query("$query") or die(mysql_error()); echo "
"; while ($row = mysql_fetch_assoc($result)) { $htmlpage = $row['htmlpage']; $fullname = rtrim($row['fullname']); $low = $row['Low']; $fullname = str_replace("\\","",$fullname); $fullname = str_replace(" ^","",$fullname); $fullname = preg_replace ("/\[[^\].]*\]/","",$fullname); $aname = $row['aname']; $i++; $result2 = mysql_query("SELECT numbercards, aname, firstname, lastname FROM Numbertable WHERE aname = '$aname' AND trim(aname) != ''") or die(mysql_error()); $row2 = mysql_fetch_assoc($result2); $firstname=$row2['firstname']; $lastname=$row2['lastname']; $aname=$row2['aname']; $firstletter = array(); $firstnamearray = array(); $firstname =strtolower($firstname); if (strpos($firstname,"/") != false) {$slashpos=strpos($firstname,"/")+1; $slashflag=1;} else {$slashflag=0;} $firstnamearray = preg_split("/[\s\/]/ ",$firstname); $firstname=""; for ($n=0;$n\r\n"; } if ($i=="") {$i=0; echo ""; }} else { $i=0; echo "
Astroland's Cards Worth ".$titlename." Beckett Low
 
"; if ($i < 10) {echo "    ";} elseif ($i<100) {echo "  ";} if ($i%2 ==1) {$backgroundstyle="style=\"background-color:beige\" ";} else {$backgroundstyle="";} echo $i."."; if ($htmlpage !="") { $image = str_replace("html","jpg",$htmlpage); if (file_exists($image)) {$fh = fopen($image, 'r'); list($width, $height) = getimagesize($image); $htmlpage = str_replace("\\","",$htmlpage); if ($width > 499 || $height > 499) {$pageopener="zoomBoxScroll";} else {$pageopener="zoomBox";} if ($pageopener=="zoomBoxScroll") { $htmlpagewindowwidth=$width+200; $htmlpagewindowheight=$height+45;} else { $htmlpagewindowwidth=$width+100; $htmlpagewindowheight=$height+195;} if ($width== 131 || $width == 130 || $width == 132) {$htmlpagewindowwidth=260;} if ($width== 135 || $width == 136 || $width == 134) {$htmlpagewindowwidth=200;} if ($height== 150 || $height == 149 || $height == 151) {$htmlpagewindowheight=385;} if ($height== 210 || $height == 211 || $height == 209) {$htmlpagewindowheight=390;} if ($width== 205 || $width == 204 || $width == 206) {$htmlpagewindowwidth=335;} if ($width== 250 || $width == 249 || $width == 251 || $width == 252) {$htmlpagewindowwidth=380;} if ($height== 312 || $width == 313 || $width == 311) {$htmlpagewindowwidth=500;} if ($height > 348 && $height < 355) {$htmlpagewindowheight=545;} if (($width== 350 || $width == 349 || $width == 351 ) && $pageopener != "zoomBoxScroll") {$htmlpagewindowwidth=450;} if ($height== 250 || $height == 249 || $height == 251) {$htmlpagewindowheight=475;} if ($width== 148 && $height == 272) {$htmlpagewindowwidth=300; $htmlpagewindowheight=470;} if ($width== 253 && $height == 313) {$htmlpagewindowwidth=400; $htmlpagewindowheight=470;} if ($width > 499 || $height > 499) {$pageopener="zoomBoxScroll";} else {$pageopener="zoomBox";} fclose($fh);} if ($width == 0) {$htmlpagewindowwidth=380; $pageopener="zoomBox";} if ($height== 0) {$htmlpagewindowheight=545;} } $firstname=str_replace("/ ","/",$firstname); if (strpos($lastname,"Mc")==1 ) { $mcpos=strpos($lastname,"Mc"); $lettertoupper = substr($lastname,$mcpos+2,1); $lastname = substr_replace($lastname,strtoupper($lettertoupper),$mcpos+2,1);} if (strpos($lastname,"(")==1 ) { $parenthpos=strpos($lastname,"("); $lettertoupper = substr($lastname,$parenthpos+1,1); $lastname = substr_replace($lastname,strtoupper($lettertoupper),$parenthpos+1,1);} if (strpos($lastname,"'")==2 ) {$apospos=strpos($lastname,"'"); $lettertoupper = substr($lastname,$apospos+1,1); $lastname = substr_replace($lastname,strtoupper($lettertoupper),$apospos+1,1);} $lastname = str_replace("?n","án;",$lastname); $lastname = str_replace("?","ñ",$lastname); $lastname = str_replace("Ño","ño",$lastname); $lastname = str_replace("Non-astros","Non-Astros",$lastname); if (substr($fullname,0,9) !="1977 TCMA" && substr($fullname,0,9) !="1978 TCMA") { if (substr($fullname,5,6) !="Choice") { $fullname = preg_replace("/# 0(?=[1-9])/", "# ", $fullname);} else { $fullname = preg_replace("/# 000(?=[1-9])/", "# 0", $fullname); $fullname = preg_replace("/# 00(?=[1-9])/", "# ", $fullname); } $fullname = preg_replace("/# 000(?=[1-9])/", "# ", $fullname); $fullname = preg_replace("/# 00(?=[1-9])/", "# ", $fullname); } $fullname = preg_replace("/ - 000(?=[1-9])/", "-   ", $fullname); $fullname = preg_replace("/ - 00(?=[1-9])/", "-  ", $fullname); $fullname = preg_replace("/ - 0(?=[1-9])/", "- ", $fullname); $fullname = preg_replace("/P000(?=[1-9])/", "P", $fullname); $fullname = preg_replace("/P00(?=[1-9])/", "P", $fullname); $fullname = preg_replace("/P0(?=[1-9])/", "P", $fullname); $fullname = preg_replace("/C000(?=[1-9])/", "C", $fullname); $fullname = preg_replace("/C00(?=[1-9])/", "C", $fullname); $fullname = preg_replace("/C0(?=[1-9])/", "C", $fullname); $fullname = preg_replace("/UH000(?=[1-9])/", "UH", $fullname); $fullname = preg_replace("/UH00(?=[1-9])/", "UH", $fullname); $fullname = preg_replace("/UH0(?=[1-9])/", "UH", $fullname); $fullname = preg_replace("/US000(?=[1-9])/", "UH", $fullname); $fullname = preg_replace("/US00(?=[1-9])/", "UH", $fullname); $fullname = preg_replace("/US0(?=[1-9])/", "UH", $fullname); $fullname = preg_replace("/US-000(?=[1-9])/", "US-", $fullname); $fullname = preg_replace("/US-00(?=[1-9])/", "US-", $fullname); $fullname = preg_replace("/US-0(?=[1-9])/", "US-", $fullname); $fullname = preg_replace("/T000(?=[1-9])/", "T", $fullname); $fullname = preg_replace("/T00(?=[1-9])/", "T", $fullname); $fullname = preg_replace("/T0(?=[1-9])/", "T", $fullname); $fullname = preg_replace("/10000/", "10,000", $fullname); $fullname = preg_replace("/Topps Chrome Red Xfractor/", "Topps Chrome (Red) Xfractor", $fullname); $fullname = preg_replace("/Topps Chrome Update Red Xfractor/", "Topps Chrome Update (Red) Xfractor", $fullname); $fullname = preg_replace("/2004 Topps Chrome White Refractor/", "2004 Topps Chrome (White) Refractor", $fullname); $fullname = preg_replace("/2005 Topps Chrome White Refractor/", "2005 Topps Chrome (White) Refractor", $fullname); if (strpos($fullname,"First 2,000 Printed") != false) {$fullname = str_replace("First 2,000 Printed","",$fullname); $first2000flag=1;} if (strpos($fullname,"one of 2000") != false) {$fullname = str_replace("one of 2000","",$fullname); $oneof2000flag=1;} if (strpos($fullname,"one of 500") != false) {$fullname = str_replace("one of 500","",$fullname); $oneof500flag=1;} if (strpos($fullname,"Rated Rookie") != false) {$fullname = str_replace("Rated Rookie","",$fullname); $ratedrookieflag=1;} if ($htmlpage !="") {$htmlcounter++; $hrefstring="";} else {$hrefstring="";} echo $hrefstring; if (strpos($firstname,"ulti") != 0) {$firstname="";} if (strpos($firstname,"ple And Q") != 0) {$firstname="";} if ($firstname == "Team Photo") {$firstname="";} if (strpos($firstname,"Dual/Triple") != 0) {$firstname="";} //if ($firstname == "Rookie Dual/Triple Player") {$firstname="";} if ($firstname == "Team Leader") {$firstname="";} if ($firstname == "Coaches") {$firstname="";} if ($firstname == "Major League Logo") {$firstname="";} echo $fullname." ".$firstname." ".$lastname."\r\n"; if ($first2000flag==1) {echo "1st 2,000 Printed"; $first2000flag=0;} if ($oneof2000flag==1) {echo "one of 2000"; $oneof2000flag=0;} if ($oneof500flag==1) {echo "one of 500"; $oneof500flag=0;} if ($ratedrookieflag==1) {echo "Rated Rookie"; $ratedrookieflag=0;} echo $suffix."
Sorry, but feel free to try again!
You can reference links to the info on this page by going to the Beckett Low Breakdown here"; $crappedout="Y"; } if ($i ==1) {$cardtense="Card";} else {$cardtense = "Cards";} if ($crappedout !="Y") {echo "
".$i." Different ".$cardtense; $worth = $i*$queryvariable; if ($worth==0) {echo "
Worth, according to Beckett, alas, zero.";} else { echo "
Worth $".number_format($worth,2);}} if ($i>0) {echo "

And ".$htmlcounter." with "; if ($htmlcounter==1) {echo "a link";} else {echo "links";} if ($htmlcounter==1) {echo " to a scan";} else {echo " to scans";}} echo "

"; if ($searchstring) {mysql_close ($connid);} echo "

";


Astroland:
Search Engine Home Page Doubles For Sale or Trade Doubles Search Engine
Autographed Card Counter Beckett Low Breakdown Beckett Low Breakdown Bowman Chrome Rainbow Finder
Bowman Chrome Worksheets Complete Sets Game Bat Card Counter Game-Used "Fabric" Card Counter
The Hundred Club Jersey-Numbered Numbereds Leaf Certified Cuts Worksheet Leaf Certified Mats Worksheets
Minor League Singles Minor League Teamsets Numbered Card Counter Parallel Want Finder
Topps Chrome Worksheets Upper Deck Heroes Worksheet Upper Deck Special F/X Worksheet Wantlist Search Engine
Cards by Year