prepare("SELECT * FROM parts WHERE part1 = :part1 AND man = :man AND (supp = :supp OR supp = :supp2) order by qty DESC"); $stmt->bindParam(':part1', $part1); $stmt->bindParam(':man', $man); $stmt->bindParam(':supp', $supp); $stmt->bindParam(':supp2', $supp2); } elseif (isset($_GET['ID'])) { $stmt = $dbh->prepare("SELECT * FROM parts WHERE part1 = :part1 AND man = :man AND ID = :recid"); $stmt->bindParam(':part1', $part1); $stmt->bindParam(':man', $man); $stmt->bindParam(':recid', $recid); } else { $stmt = $dbh->prepare("SELECT * FROM parts WHERE part1 = :part1 AND man = :man order by qty DESC"); $stmt->bindParam(':part1', $part1); $stmt->bindParam(':man', $man); } $stmt->execute(); $row = $stmt->fetch(PDO::FETCH_ASSOC); //checks for unknown record id but correct part1 and man// if((isset($_GET['ID'])) && ($row['part1'] == "")) { $stmt = $dbh->prepare("SELECT * FROM parts WHERE part1 = :part1 AND man = :man order by qty DESC"); $stmt->bindParam(':part1', $part1); $stmt->bindParam(':man', $man); $stmt->execute(); $row = $stmt->fetch(PDO::FETCH_ASSOC); } //-----------------// $man = $row['man']; $part1 = $row['part1']; $part2 = $row['part2']; $part3 = $row['part3']; if ($row['part1'] != "" ) { if ($row['man'] != "" ) { $stmt2 = $dbh->prepare("SELECT * FROM manufacturers WHERE name LIKE '$man%'"); $stmt2->execute(); $manrow = $stmt2->fetch(PDO::FETCH_ASSOC); }; $stmt3 = $dbh->prepare("SELECT * FROM datapath WHERE part = '$part2'"); $stmt3->execute(); $datarow = $stmt3->fetch(PDO::FETCH_ASSOC); $stmt4 = $dbh->prepare("SELECT * FROM data WHERE part1 = '$part1'"); $stmt4->execute(); $dataext = $stmt4->fetch(PDO::FETCH_ASSOC); $stmt5 = $dbh->prepare("SELECT * FROM descriptions WHERE part3 = '$part2' AND man = '$man'"); $stmt5->execute(); $descrow = $stmt5->fetch(PDO::FETCH_ASSOC); $stmt6 = $dbh->prepare("SELECT * FROM shop WHERE sku LIKE '$part1' AND vendor LIKE '$man'"); $stmt6->execute(); $shoprow = $stmt6->fetch(PDO::FETCH_ASSOC); $et_username = $_COOKIE['et_username']; $et_company = $_COOKIE['et_company']; $et_country = $_COOKIE['et_country']; $et_email = $_COOKIE['et_email']; $et_phone = $_COOKIE['et_phone']; if ($row['supp'] == "ETRS") { $stk = "1" ; } elseif ($row['supp'] == "ETS") { $stk = "1" ; }; ?> <? echo $part1; ?> from <? echo $man; ?> | Euro-Tech <? echo $part1; ?> from <? echo $man; ?> | <? echo $part3; ?> | Euro-Tech , Euro-Tech, Components, Electronic Components, Integrated Circuits, Resistor, Capacitor, Connector">

:

Product Image

<? echo $row['part2'] ; ?> from <? echo $row['man'] ; ?>

Image of Part Number <? echo strtoupper($row['part2']) ;?>

Image of Part Number <? echo strtoupper($row['part2']) ; ?>

Image of Part Number <? echo strtoupper($row['part2']) ; ?> Awaiting Image1 Awaiting Image2

The image of above is for illustrative purposes only and may or may not represent the actual item. Please refer to the product data.We are currently awaiting an image of . Please refer to the product data sheet for information

RoHS Compliant

RoHS Unconfirmed

Manufacturer's Part Number:

Description of item:

Manufacturer:

Price: Available on application

Possible alternative part numbers: ,

Base part number:

Stripped part number:

Stock Code:

Category: ".$shoprow['type']."

"; }?> 0))|| (($row['supp'] == "ETS") && ($row['qty'] > 0))|| (($row['supp'] == "COTR551") && ($row['qty'] > 0))|| (($row['supp'] == "APCT553") && ($row['qty'] > 0))) { ?>

available from stock in our UK warehouse.

Further stock may be available on short lead time. Contact Us

0){ ?>

This item is available within 7 Days.

Contact Us using the below form for further information.

Please Contact Us for availability.

Contact Euro-Tech using the RFQ button below or call us on +44 (0) 20 8760 7302

HERE "; }?>

Stock Quantity: Pieces
Available Quantity: Contact US
Available Quantity: Pieces
£ P.O.A.

Product Specifications

Other " .$man." components offered by Euro-Tech .
"; ///use below - tests to see if we have ets or etrs stock/// $stmt8 = $dbh->prepare("SELECT DISTINCT * FROM parts where man='$man' AND (supp='ETRS' OR supp='ETS') AND qty>'1' ORDER BY random() LIMIT 12"); $stmt8->execute(); $row8 = $stmt8->fetch(PDO::FETCH_ASSOC); if ($row8['part1'] =="") { $stmt8 = "SELECT DISTINCT * FROM parts where man='$man' ORDER BY random() LIMIT 12"; } else {$stmt8 = "SELECT DISTINCT * FROM parts where man='$man' AND (supp='ETRS' OR supp='ETS') AND qty>'1' ORDER BY random() LIMIT 12" ;}; ?>

query($stmt8) as $tablerow) { $incr = ($incr == 3) ? 1 : $incr + 1; if($incr == 1) echo ""; print ""; if($incr == 3) echo ""; } if($incr == 1) echo ""; if($incr == 2) echo ""; if($incr == 3) echo ""; ?>

"."" .$tablerow['part2'] ."

Euro-Tech (Export) Ltd. (Euro Tech) acknowledges the copyright of all logos and brand names displayed on this site and does not in any way infer authorised distributor status or any other connection to the original manufacturer of the products displayed or offered for sale unless specifically stated.

Subscribe to Our Newsletter

SUBSCRIBE