\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 aname, firstname, lastname FROM Numbertable WHERE aname = '".$searchstring."'"; $result=mysql_query($query); while($row = mysql_fetch_array($result)){ $titlename = $row['firstname']." ".$row['lastname']; $titlename=strtolower($titlename); $titlename=ucwords($titlename); } mysql_close ($connid); echo ""; echo "".$titlename."'s Numbered Cards 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 = "aname = '$searchstring' AND fullname REGEXP '\/[0-9]*)'"; $query = "SELECT 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']); $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' ") or die(mysql_error()); $row2 = mysql_fetch_assoc($result2); $firstname=$row2['firstname']; $lastname=$row2['lastname']; $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 Numbered Cards for ".str_replace("Ñ","ñ",rtrim(ltrim($titlename)))."
 
"; 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;} } $nbspvar ="       "; if (strlen($fullname) > 80) { $offset = 0; // initial offset is 0 $spaceCounter = 0; // Check the rest of the string for spaces while($offset = strpos($fullname," ",$offset + 1)){ if ($offset > 40 && $offset < 64 && strpos($fullname,"#")!=$offset - 1) {$breakpoint = $offset;} } if ($row['htmlpage'] != "") { $twolinehrefmarker="Y"; $fullname=substr_replace($fullname,"
".$nbspvar.$nbspvar.$nbspvar,$breakpoint,0);} else { $twolinehrefmarker="N"; $fullname=substr_replace($fullname,"
".$nbspvar.$nbspvar.$nbspvar,$breakpoint,0);}} if (strpos($fullname,"(") != false) { $parenthesecheckers = substr($fullname,strpos($fullname,"(")+1,1); if ($parenthesecheckers !="" && preg_match("/[p123456789]/",$parenthesecheckers)) { $suffix = substr($fullname,strpos($fullname,"(")); $fullname = substr($fullname,0,strpos($fullname,"("));} else {$suffix="";} } else {$suffix="";} $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("/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 ($twolinehrefmarker=="Y") { $hrefplusspaces=$nbspvar.$nbspvar.$nbspvar.$hrefstring; $fullname = str_replace($nbspvar.$nbspvar.$nbspvar,$hrefplusspaces,$fullname); echo $fullname."";} else {echo $fullname."";} 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!
Please enter a search.";} if ($i ==1) {$cardtense="Card";} else {$cardtense = "Cards";} echo "
".$i." Different ".$cardtense; 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 High 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