$onegroup
"; */ $onebrand = preg_split("/\^/", $onegroup, -1, PREG_SPLIT_NO_EMPTY); /* echo "$onebrand[0]
"; */ $htmodlist .= "$onebrand[0]
"; $cbrand = "|$onebrand[1]|"; $onemodel = preg_split("/\|/", $cbrand, -1, PREG_SPLIT_NO_EMPTY); foreach($onemodel as $mod){ $mqu = "SELECT models FROM parts WHERE parts.models LIKE '%$onebrand[0]%' AND parts.models LIKE '%$mod%' AND partnum != '".$row_Recordset1['partnum']."' AND gen_num != '".$row_Recordset1['gen_num']."' limit 1"; # echo "$mqu
$nomods"; $mod_res = mysqli_query($i_access,$mqu); $modrows = mysqli_num_rows($mod_res); /* echo "$modrows partial matches found
"; */ if($modrows < 1){ $htmodlist .= "$mod
"; } else{ while($found = mysqli_fetch_row($mod_res)){ foreach($found as $fndstr){ $fndstr = preg_replace("/(#.*?\^)/", "|", $fndstr); /* echo "$fndstr
"; */ $onefoundmod = preg_split("/\|/", $fndstr, -1, PREG_SPLIT_NO_EMPTY); foreach($onefoundmod as $thisfoundmod){ /* echo "$thisfoundmod..."; */ if(($thisfoundmod == "$mod") || ($thisfoundmod == "g$mod")){ /* echo "Accessory matched $thisfoundmod
"; */ if(!strstr($htmodlist, "dyn_models_accys.php?modnum=$mod&brand=$onebrand[0]")){ $htmodlist = str_replace("
$mod
", "
", $htmodlist); $htmodlist .= "$mod
"; } $yesacc++; } elseif((!strstr($htmodlist, "
$mod
")) && (!strstr($htmodlist, "dyn_models_accys.php?modnum=$mod&brand=$onebrand[0]"))){ $htmodlist .= "$mod
"; } /* echo "
"; */ } } } } } } } /* echo "$yesacc exact matches
"; */ # echo "$htmodlist"; /* End current fuckup */ # begin associated numbers $ctml = ""; $alt_links = ""; if(($row_Recordset1['match'] != "") && ($row_Recordset1['match'] != $row_Recordset1['partnum'])){ $p = explode('|', $row_Recordset1['match'], 11); foreach($p as $j){ if(($j != $row_Recordset1['partnum']) && ($j != $row_Recordset1['gen_num']) && ($j != "") && (!stristr($j, "used")) && (!stristr($j, "repack")) && (!stristr($j, "refurb"))){ $ctml .= " $j
\n"; } if($j != ""){ $alt_link_query = "select cart_url from parts where cart_url not like '".$row_Recordset1['cart_url']."' and partnum = '$j' and av NOT REGEXP '[3-5]' limit 1"; $alt_link_res = mysqli_query($i_access,$alt_link_query) or die(mysqli_error()); $alt_link_rows = mysqli_num_rows($alt_link_res); if($alt_link_rows > 0){ $alt_link_recset = mysqli_fetch_row($alt_link_res); if($alt_link_recset[0] != "http://www.newremotecontrol.com".$_SERVER['PHP_SELF']."?".$_SERVER['QUERY_STRING']){ $alt_links .= "$j
\n"; $subcount++; } } } } } # set some variables if(stristr($row_Recordset1['partnum'], "used")){ $unr = "USED"; } elseif(stristr($row_Recordset1['partnum'], "refurb")){ $unr = "REFURBISHED"; } elseif(stristr($row_Recordset1['partnum'], "repack")){ $unr = "REPACKAGED NEW"; } elseif((stristr($row_Recordset1['desc'], "book")) || (stristr($row_Recordset1['desc'], "manual"))){ $unr = " "; } else{ $unr = "NEW"; } if($row_Recordset1['instok'] > 1){ $plur = "pieces"; } else{ $plur = "piece"; } if(strstr($row_Recordset1['av'], "|")){ $avc = explode("|", $row_Recordset1['av']); $avcon = $avc[0]; } else{ $avcon = $row_Recordset1['av']; } if(preg_match('/[7-9]/', $row_Recordset1['qd'])){ $spec = "Special!
Sale Price - "; } if(preg_match('/^[3-7]/', $avcon)){ $col3_border_color = "border-color:#FF0000;"; }else{ $col3_border_color = "border-color:#00FF00;"; } if($row_Recordset1['subpart'] != ""){ if(preg_match("/.*Except.*/", $row_Recordset1['ers_sub_note'])){ $ubnegnote++; } $subcount++; $man_sub_query = "SELECT url, gen_num, cart_url, brand, price, av FROM parts WHERE parts.partnum = ('".$row_Recordset1['subpart']."')"; $man_sub_result = mysqli_query($i_access,"$man_sub_query") or die ('manuf sub link routine failed'); while($m_s_r = mysqli_fetch_row($man_sub_result)){ $ms_thimg = ""; $ms_img_query = "select `url` from `img_url` where `partnum` = ('".$row_Recordset1['subpart']."')"; $ms_img_result = mysqli_query($i_access,$ms_img_query); if(mysqli_num_rows($ms_img_result)>0){ $ms_img= mysqli_fetch_assoc($ms_img_result); $th_src = thumbLink($ms_img['url']); $ms_thimg = "
"; } $msrlink = "$m_s_r[0]"; $msrgen_num = "$m_s_r[1]"; $msrcart = "$m_s_r[2]"; $msrbrand = strtolower($m_s_r[3]); if($m_s_r[5] < 3){ $msrprice = "$".$m_s_r[4].$ms_thimg; $avsub++; }else{ $msrprice = "$ms_thimg"; } if($msrlink != ""){ if(file_exists("/home/newremot/public_html/$msrbrand/catalog_item.php")){ $msrlink = "http://www.$msrbrand.newremotecontrol.com/catalog_item.php?catnum=".$row_Recordset1['subpart'].(isset($_GET['refnum'])?"&refnum=".$_GET['refnum']."+Sub":""); } } if($msrlink != ""){ $man_sub_link = "".$row_Recordset1['subpart'].""; }elseif((!preg_match('/^http/', $m_s_r[1])) && ($msrcart != "")){ $ers_sub_link = "".$row_Recordset1['subpart'].""; }else{ $man_sub_link = $row_Recordset1['subpart']; } if($row_Recordset1['subpart'] != $msrgen_num){ $man_sub_link .= "
$msrgen_num"; } } } if(($row_Recordset1['ers_sub'] != "") && (!strstr($row_Recordset1['ers_sub'], "|"))){ if(preg_match("/.*Except.*/", $row_Recordset1['ers_sub_note'])){ $ubnegnote++; } $subcount++; $ers_sub_query = "SELECT url, gen_num, cart_url, brand, price, av FROM parts WHERE parts.partnum = ('".$row_Recordset1['ers_sub']."')"; $ers_sub_result = @mysqli_query($i_access,"$ers_sub_query") or die ('ers sub link routine failed'); while($e_s_r = mysqli_fetch_row($ers_sub_result)){ $es_thimg = ""; $es_img_query = "select `url` from `img_url` where `partnum` = '".$row_Recordset1['ers_sub']."'"; $es_img_result = mysqli_query($i_access,$es_img_query); if(mysqli_num_rows($es_img_result)>0){ $es_img= mysqli_fetch_assoc($es_img_result); $th_src = thumbLink($es_img['url']); $es_thimg = "
"; } $esrlink = "$e_s_r[0]"; $esrgen_num = "$e_s_r[1]"; $esrcart = "$e_s_r[2]"; $esrbrand = strtolower($e_s_r[3]); if($e_s_r[5] <3){ $esrprice = "$".$e_s_r[4].$es_thimg."
"; $avsub++; } else{ $esrprice = "$es_thimg
"; } if($esrlink != ""){ if(file_exists("/home/newremot/public_html/$esrbrand/catalog_item.php")){ $esrlink = "http://www.$esrbrand.newremotecontrol.com/catalog_item.php?catnum=".$row_Recordset1['ers_sub'].(isset($_GET['refnum'])?"&refnum=".$_GET['refnum']."+Sub":""); } else{ $esrlink = $esrcart; } $ers_sub_link = "".$row_Recordset1['ers_sub']."
$esrprice"; }elseif((!preg_match('/^http/', $e_s_r[0])) && ($esrcart != "")){ $ers_sub_link = "".$row_Recordset1['ers_sub']."
$esrprice"; }else{ $ers_sub_link = $row_Recordset1['ers_sub']; } if($row_Recordset1['ers_sub'] != $esrgen_num){ $ers_sub_link .= "
$esrgen_num\n"; } } } /* continued on 736 */ elseif(strstr($row_Recordset1['ers_sub'], "|")){ if(preg_match("/.*Except.*/", $row_Recordset1['ers_sub_note'])){ $ubnegnote++; } $esubpn_mult = explode("|", $row_Recordset1['ers_sub']); $esubnot_mult = explode("|",$row_Recordset1['ers_sub_note']); foreach($esubpn_mult as $key => $value){ $esubray_mult[$value] = $esubnot_mult[$key]; } foreach($esubray_mult as $spn => $spnote){ if(preg_match("/.*Except.*/", $row_Recordset1['ers_sub_note'])){ $ubnegnote++; } $subcount++; $ers_sub_query = "SELECT url, gen_num, cart_url, brand, price, av FROM parts WHERE parts.partnum = ('$spn')"; $ers_sub_result = @mysqli_query($i_access,"$ers_sub_query") or die ('ers sub link routine failed'); while($e_s_r = mysqli_fetch_row($ers_sub_result)){ $es_thimg = ""; $es_img_query = "select `url` from `img_url` where `partnum` = '$spn'"; $es_img_result = mysqli_query($i_access,$es_img_query); if(mysqli_num_rows($es_img_result)>0){ $es_img= mysqli_fetch_assoc($es_img_result); $th_src = thumbLink($es_img['url']); $es_thimg = "\n\n
\n"; } $esrprice = ""; $esrlink = "$e_s_r[0]"; $esrgen_num = "$e_s_r[1]"; $esrcart = "$e_s_r[2]"; $esrbrand = strtolower($e_s_r[3]); if($e_s_r[5] < 3){ $esrprice = "$".$e_s_r[4].$es_thimg."
"; $avsub++; } else{ $esrprice = "$es_thimg"; } if($esrlink != ""){ # $ers_sub_link = ""; if(file_exists("/home/newremot/public_html/$esrbrand/catalog_item.php")){ $esrlink = "http://www.$esrbrand.newremotecontrol.com/catalog_item.php?catnum=$spn".(isset($_GET['refnum'])?"&refnum=".$_GET['refnum']."+Sub":"").""; }else{ $esrlink = $esrcart; } $ers_sub_link .= "$spn
$esrprice"; }elseif((!preg_match('/^http/', $e_s_r[0])) && ($esrcart != "")){ $ers_sub_link .= "$spn
$esrprice"; }else{ $ers_sub_link = "$spn"; } if($spn != $esrgen_num){ $ers_sub_link .= "
$esrgen_num"; } $ers_sub_link .= "
$spnote
___________________\n"; } } } if(($row_Recordset1['gen_sub'] != "") && ($row_Recordset1['gen_sub'] != $row_Recordset1['partnum'])){ $gen_sub_query = "SELECT url, gen_num, price, av FROM parts WHERE parts.partnum = ('".$row_Recordset1['gen_sub']."')"; $gen_sub_result = @mysqli_query($i_access,"$gen_sub_query") or die ('gen sub link routine failed'); while($g_s_r = mysqli_fetch_row($gen_sub_result)){ $subcount++; $gsrlink = "http://www.newremotecontrol.com/Mfrs/OtherBrands/Def/dyn_part_data.php?catnum=".$row_Recordset1['gen_sub']; $gsrgen_num = $g_s_r[1]; if($g_s_r[3] <3){ $gsrprice = "$".$g_s_r[2]; $avsub++; } else{ $gsrprice = ""; } if($gsrlink != ""){ $gen_sub_link = "".$row_Recordset1['gen_sub'].""; }else{ $gen_sub_link = $row_Recordset1['gen_sub']; } } } if($avsub =0){ $col4_border_color = "border-color:#FF0000;"; }else{ $col4_border_color = "border-color:#00FF00;"; } if($subcount > 1){ $subplural = "s are"; } # do a little battery stuff if($row_Recordset1['batt'] != ""){ $bt = explode('|', $row_Recordset1['batt']); if(!stristr($bt[0], "CR")){ $bat_pn = "$bt[1]X$bt[0]"; }else{ $bat_pn = "$bt[0]"; $bat_thum = "http://www.newtvremotes.com/Mfrs/Generic/CR2025.jpg"; } if($bt[1] == "1"){ $batplur = "y"; $batplur_it = "it"; }else{ $batplur = "ies"; $batplur_it = "they"; } $query_Recordset3 = "SELECT * FROM parts WHERE partnum = '$bat_pn'"; $Recordset3 = mysqli_query($i_access,$query_Recordset3) or die(mysqli_error()); $row_Recordset3 = mysqli_fetch_assoc($Recordset3); $totalRows_Recordset3 = mysqli_num_rows($Recordset3); if($bt[2] == "NO"){ $batline = "Include $bt[1] $bt[0] batter$batplur
for each remote?"; }else{ # $batline = "$bt[0] batter$batplur included in package, but $batplur_it may be old.
Include $bt[1] fresh, new $bt[0] batter$batplur for each remote?"; $batline = "$bt[0] batter$batplur included in package from ".ucwords(strtolower($row_Recordset1['brand']))."."; } } $stuff = 0; if (!$RemShop->IsEmpty()) { while (!$RemShop->EOF()) { $stuff += $RemShop->DisplayInfo("Quantity"); $RemShop->MoveNext(); } $RemShop->MoveFirst(); } ?> 0) { $row_Recordset1 = WAEC_findRecordMySQL_i($Recordset1, "ID", $ATC_itemID); if ($row_Recordset1) { $ATC_itemName = "".$row_Recordset1['partnum'] ."";// column binding $ATC_itemDescription = "".$row_Recordset1['brand'] ." ".$row_Recordset1['type'] ." ".$row_Recordset1['desc'] ."";// column binding $ATC_itemThumbnail = "$cart_th_src";// column binding $ATC_itemWeight = floatval("".$row_Recordset1['wt'] ."");// column binding $ATC_itemSKU = "".$_POST['fr'] .""; $ATC_itemLimit = "".$_POST['cil'].""; $ATC_itemQuantity = "".$_POST["RemShop_1_Quantity_Add"] ."";// column binding $ATC_itemPrice = floatval("".$row_Recordset1['price'] ."");// column binding $ATC_itemModel = "".$_POST["RemShop_1_Model_Add"] ."";// column binding mysqli_data_seek($Recordset1, 0); $row_Recordset1 = mysqli_fetch_assoc($Recordset1); } } $ATC_itemQuantity = floatval($ATC_itemQuantity); if (is_numeric($ATC_itemQuantity) && $ATC_itemQuantity != 0) { $RemShop->AddToCart($ATC_AddIfIn, $ATC_RedirectIfIn, $ATC_itemID, $ATC_itemName, $ATC_itemDescription, $ATC_itemThumbnail, $ATC_itemWeight, $ATC_itemQuantity, $ATC_itemPrice, $ATC_itemModel, $ATC_itemSKU, $ATC_itemLimit); if ($ATC_RedirectAfter != "" && $RemShop->redirStr == "") { $RemShop->redirStr = $ATC_RedirectAfter; } if (isset($_SERVER['QUERY_STRING']) && $_SERVER['QUERY_STRING'] != "") { $_SESSION['WAEC_ContinueRedirect'] = $_SERVER['PHP_SELF']."?".$_SERVER['QUERY_STRING']; } else { $_SESSION['WAEC_ContinueRedirect'] = $_SERVER['PHP_SELF']; } } } ?> AddToCart($ATC_AddIfIn, $ATC_RedirectIfIn, $ATC_itemID, $ATC_itemName, $ATC_itemDescription, $ATC_itemThumbnail, $ATC_itemWeight, $ATC_itemQuantity, $ATC_itemPrice, $ATC_itemModel, $ATC_itemSKU, $ATC_itemLimit); if ($ATC_RedirectAfter != "" && $cart->redirStr == "") { $cart->redirStr = $ATC_RedirectAfter; } if (isset($_SERVER['QUERY_STRING']) && $_SERVER['QUERY_STRING'] != "") { $_SESSION['WAEC_ContinueRedirect'] = $_SERVER['PHP_SELF']."?".$_SERVER['QUERY_STRING']; } else { $_SESSION['WAEC_ContinueRedirect'] = $_SERVER['PHP_SELF']; } } } ?> redirStr != "") { header("Location: ".$RemShop->redirStr); } ?> " /> , " />

	New Original Equipment Remote Controls From Electronic Repair Service Thomasville, Ga
The One Stop Shop For Most Brands Of Replacement Remote Controls TV, VCR, TV/VCR Combo, DVD, Audio	Select Brand Brand

Apex Main Index

Manufacturer ID $snote[1] \n"; } }?> Associated Part Numbers \n$ctml\n"; }?> 3){ echo " Originally Supplied With Models: "; if($yesacc > 0){ echo " (Models with links have additional accessories available. Follow links to find manuals, cables, battery covers, etc. for that model.) \n"; } echo "$htmodlist "; }else{ echo "$nomods "; } ?>

Live Inventory Information ".$row_Recordset1['brand']." ".$row_Recordset1['type']." ".$row_Recordset1['desc']; ?> Part Number: Manufacturer ID: ".$row_Recordset1['gen_num']." ";}?> \n"; print "\t$prtnote[0] \n"; print "\t \n "; } } ?> $longv){ if(strstr($bodt[1], $abv)){ $real_month = substr_replace($bodt[1], $longv, 0,3); } } print "$pagetime This Normally Stocked item is currently on backorder from the manufacturer. Estimated shipping date is $real_month. \n\n\n\n"; } elseif($bodt[0] == "7"){ print "$pagetime This is a Non-Stocking item. Available for order. No cancellations, no returns except warranty exchange. Estimated shipping date is $bodt[1]. \n\n\n\n"; } } else */ // { /* switch ($avcon){ case 0: if(($row_Recordset1['instok'] < 1) && ($row_Recordset1['minstok'] < 1)){ print "$pagetime $ava2 \n\n\n"; } elseif(($row_Recordset1['instok'] < 1) && ($row_Recordset1['minstok'] > 0)){ print "$pagetime Depleted Stock Inventory, currently enroute from our supplier. Normally restocked within 4 days."; if($row_Recordset1['minstok'] > 1){ print " HOT ITEM ! Order now to reserve yours."; } print " \n\n\n"; } elseif($row_Recordset1['instok'] >= 10){ print "$pagetime 10+ $plur $ava3 \n\n\n"; */# print "$pagetime ".$row_Recordset1['instok']." $plur $ava3 \n\n\n"; /* } elseif($row_Recordset1['instok'] <= 10){ print "$pagetime ".$row_Recordset1['instok']." $plur $ava3 \n\n\n"; } break; case 1: print "$pagetime $ava2 \n\n\n"; break; case 2: $lim = 1; if($row_Recordset1['instok'] >= 10){ print "$pagetime $ava1 10+ $plur currently in stock. \n\n\n"; */# print "$pagetime $ava1 ".$row_Recordset1['instok']." $plur currently in stock. \n\n\n"; /* } elseif(($row_Recordset1['instok'] <= 9) && ($row_Recordset1['instok'] > 0)){ print "$pagetime $ava1 ".$row_Recordset1['instok']." $plur currently in stock. \n\n\n"; } elseif($row_Recordset1['instok'] < 1){ print "$pagetime $ava0 Due to recent orders, our remaining supply of this part appears to be depleted. Email Customer Service for the absolute status of this part."; if($subcount>0){ print " $subcount substitute$subplural listed."; } else{ print " No suitable substitutes found for this item. "; */ /* if(stristr($row_Recordset1['desc'], "remote")){ print "Repairing your old remote may be possible."; } */ /* } print " \n\n\n"; $d_abl .= " disabled"; } break; case 3: print "$pagetime $ava0"; if($subcount>0){ print " $subcount substitute$subplural listed."; } else{ print " No suitable substitutes found for this item. "; */ /* if(stristr($row_Recordset1['desc'], "remote")){ print "Repairing your old remote may be possible."; } */ /* } print " \n\n\n"; $d_abl .= " disabled"; break; case 4: print "$pagetime This item is Currently Unavailable. Use Sub if listed. \n\n\n"; $d_abl .= " disabled"; break; case 5: print "$pagetime This item is listed in our catalog. Exact inventory status cannot be determined at this time. \n\n\n"; $d_abl .= " disabled"; break; case 8: print "$pagetime $ava4 \n\n\n"; break; case 9: print "$pagetime This part can be ordered, but we don't know if the manufacturer can actually supply it. \n\n\n"; break; } */// } if($row_Recordset1['av'] == 3){ ?> Item Is Not Available From This Store $row_Recordset1['price']){ print "\tMSRP - $ ".$row_Recordset1['mfrprice']." \n\n\n"; print "\t$spec$".$row_Recordset1['price']."\n\n\n"; }else{ print "\t$spec$".$row_Recordset1['price']."\n\n\n\n\n"; } if((stristr($row_Recordset1['desc'], "book")) || (stristr($row_Recordset1['desc'], "manual"))){ print " All Literature Sales Are Final\n\n\n"; } */ ?> " target="_self"> What You See Is What You Get The item shipped will be identical to the image posted on this page.

class="Gk_AtcColumn" align="center"> Substitutes For This ".$row_Recordset1['desc']." listed elsewhere in our catalog. "; if($row_Recordset1['subpart'] != ""){ echo " Manufacturers Sub: \n"; echo "$man_sub_link  $msrprice ".$row_Recordset1['man_sub_note']." \n"; } if($row_Recordset1['ers_sub'] != ""){ if(!strstr($row_Recordset1['ers_sub'], "|")){ if(!stristr($row_Recordset1['ers_sub_note'], "not a sub")){ echo " ERS Sub: \n"; } elseif(stristr($row_Recordset1['ers_sub_note'], "not a sub")){ echo " Reference: \n"; } echo "$ers_sub_link".$row_Recordset1['ers_sub_note']." \n"; } elseif(strstr($row_Recordset1['ers_sub'], "|")){ if(!stristr($row_Recordset1['ers_sub_note'], "not a sub")){ echo " ERS Sub: \n"; } else{ echo " ERS Reference: \n"; } echo "$ers_sub_link \n"; } } if($row_Recordset1['gen_sub'] != ""){ echo " Generic Sub: \n"; echo "$gen_sub_link  $gsrprice ".$row_Recordset1['gen_sub_note']."\n"; } if(($row_Recordset1['clone'] != "")&&($clon_sub_link != "")){ echo " Clone Remote: \n"; echo "$clon_sub_link  $csrprice ".$row_Recordset1['clone_sub_note']."\n"; } if($alt_links != ""){ echo " Other Versions: \n"; echo "$alt_links "; } echo "  "; if ($ubnegnote >0){ if($ubnegnote > 1){ $subnegplural = "ions Listed "; } echo " Substitut".$subnegplural."Above May Not Have All Of The Features Of The Original Remote Control. Exceptions Are Listed. "; } } ?>

©1996 Electronic Repair Service of Thomasville, Georgia-An American Small Business. All Rights Reserved. All offers, promotions & prices are subject to change without notice. ERS is not responsible for any typographical, photographic, or specification errors which may appear on our website. NewRemoteControl.com, ERS, ERSWEB, & ERSWEB Sales are Trademarks of Electronic Repair Service. All Manufacturers Images, Logos, or Text are copyright of the respective holder and are used here for the sole purpose of promoting and selling their products. All items are subject to availability. Many items sold on this site are one of a kind.