Feedback Form
01603 871055
transparent pixel transparent pixel Basket transparent pixel Login transparent pixel Contact Us transparent pixel Delivery transparent pixel Security Policy transparent pixel Your Basket shopping cart icon transparent pixel
transparent pixel
transparent pixel SSL
Home > Kitchen Door Handles > Chrome Handles > Matt Satin and Brushed Chrome Handles
left header curve Browse By Category left header curve
Home
transparent pixel
left header curve Your Discounts left header curve
Not free deliverySpend £50 & get
FREE Delivery
transparent pixel
5% discountSpend £150 & get a
5% Discount!
transparent pixel
5% discount5% discountSpend £350 & get a
10% Discount!
transparent pixel
5% discount5% discount5% discountSpend £500 & get a
15% Discount!
transparent pixel
left header curve Basket left header curve
No Items in Basket.
transparent pixel
  transparent pixel View My Basket transparent pixel  
Secure Checkout Facility
Proceed to Checkout
follow us on twitter
follow us on facebook
transparent pixel
left header curve Tips & Guides left header curve
transparent pixel
left header curve Customer Service left header curve
left header curve Newsletters left header curve
Note: Registered customers go to: Your Account to subscribe.

E-Mail Address:

Your Name:
left header curve Articles left header curve
Door Handles, Kitche..
All Articles
 A Guide to Cabinets and Cabinet Furniture
 Door Knobs can change the outlook from good to better
 How effectively Door Furniture provide Home security
 Replacing Door Furniture can make your house look better

Google Checkout Notice: Use Google Checkout ONLY if necessary as orders take an upto 14 days for delivery due to manual checks. Otherwise use our own secure (Sage pay) server checkout above which has no delay. Thank You. Google shipping

Checkout
* Your Cart is empty

Matt chrome handles & knobs provide a flat but smooth finish very similar to stainless steel but without the brushed effect.
Matt Satin and Brushed Chrome Handles
Angled Bow Handle Satin Nickel (128mm centres)
Ref: 46124
  transparent pixel More Information transparent pixel  
 £3.01 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Archer Bow Handle Satin Chrome (128mm centres)
Ref: 46136
  transparent pixel More Information transparent pixel  
 £4.05 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Barrell D Handle Satin Chrome (128mm centres)
Ref: 46148
  transparent pixel More Information transparent pixel  
 £3.78 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Bow Handle Chrome (96mm centres)
Ref: 46159
  transparent pixel More Information transparent pixel  
 £2.54 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Bow Handle Matt Chrome (160mm centres)
Ref: 37752
  transparent pixel More Information transparent pixel  
 £6.05 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Bow Handle Satin Chrome (96mm centres)
Ref: 46317
  transparent pixel More Information transparent pixel  
 £2.54 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Bow Handle Satin Chrome (128mm centres)
Ref: 46323
  transparent pixel More Information transparent pixel  
 £2.86 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Bow Handle Satin Chrome (160mm centres)
Ref: 46326
  transparent pixel More Information transparent pixel  
 £4.05 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Bow Handle Satin Chrome (224mm centres)
Ref: 46327
  transparent pixel More Information transparent pixel  
 £5.84 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Bow Handle Satin Chrome (224mm centres)
Ref: 46330
  transparent pixel More Information transparent pixel  
 £5.84 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Capricorn Bow Handle Satin Chrome (160mm centres)
Ref: 45941
  transparent pixel More Information transparent pixel  
 £5.41 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Capricorn Bow Handle Satin Chrome (128mm centres)
Ref: 45937
  transparent pixel More Information transparent pixel  
 £3.01 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Capricorn Modern Cup Handle Satin Chrome (128mm centres)
Ref: 45490
  transparent pixel More Information transparent pixel  
 £5.85 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Crossover Bow D Handle Satin Chrome (160mm centres)
Ref: 45521
  transparent pixel More Information transparent pixel  
 £7.31 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Crossover Flat D Handle Satin Chrome (160mm centres)
Ref: 45519
  transparent pixel More Information transparent pixel  
 £7.31 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Crossover Large Pull Satin Chrome (32mm centres)
Ref: 46076
  transparent pixel More Information transparent pixel  
 £4.03 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Crossover Large Pull Satin Nickel (32mm centres)
Ref: 45517
  transparent pixel More Information transparent pixel  
 £4.03 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Crossover Round Knob Satin Chrome (50mm dia)
Ref: 45513
  transparent pixel More Information transparent pixel  
 £3.63 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Crossover Small Pull Handle Satin Chrome (32mm centres)
Ref: 45516
  transparent pixel More Information transparent pixel  
 £3.63 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Crossover Square Knob Satin Chrome (46mm length)
Ref: 45572
  transparent pixel More Information transparent pixel  
 £3.80 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Curve D Handle Chrome (128mm centres)
Ref: 46113
  transparent pixel More Information transparent pixel  
 £3.35 inc VAT 
QTY: 
  transparent pixel transparent pixel  
D Handle Aluminium (160mm centres)
Ref: 45999
  transparent pixel More Information transparent pixel  
 £5.41 inc VAT 
QTY: 
  transparent pixel transparent pixel  
D Handle Matt Chrome (160mm centres)
Ref: 37749
  transparent pixel More Information transparent pixel  
 £4.28 inc VAT 
QTY: 
  transparent pixel transparent pixel  
D Handle Matt Chrome (192mm centres)
Ref: 37757
  transparent pixel More Information transparent pixel  
 £2.16 inc VAT 
QTY: 
  transparent pixel transparent pixel  
D Handle Matt Chrome (320mm centres)
Ref: 37759
  transparent pixel More Information transparent pixel  
 £3.07 inc VAT 
QTY: 
  transparent pixel transparent pixel  
D Handle Matt Chrome (448mm centres)
Ref: 37760
  transparent pixel More Information transparent pixel  
 £4.37 inc VAT 
QTY: 
  transparent pixel transparent pixel  
D Handle Matt Chrome (64mm centres)
Ref: 37753
  transparent pixel More Information transparent pixel  
 £1.21 inc VAT 
QTY: 
  transparent pixel transparent pixel  
D Handle Matt Chrome (64mm centres)
Ref: 37761
  transparent pixel More Information transparent pixel  
 £5.76 inc VAT 
QTY: 
  transparent pixel transparent pixel  
D Handle Satin Chrome (192mm centres)
Ref: 46149
  transparent pixel More Information transparent pixel  
 £10.11 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Dimple Tapered Bow Handle Satin Chrome (96mm centres)
Ref: 46070
  transparent pixel More Information transparent pixel  
 £2.87 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Dimpled Bow Handle Satin Chrome (128mm centres)
Ref: 45575
  transparent pixel More Information transparent pixel  
 £5.52 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Dimpled Bow Handle Satin Chrome (128mm centres)
Ref: 46064
  transparent pixel More Information transparent pixel  
 £7.54 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Dimpled Bow Handle Satin Chrome (96mm centres)
Ref: 45526
  transparent pixel More Information transparent pixel  
 £3.01 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Dimpled Knob Satin Chrome ( 28mm diameter)
Ref: 46012
  transparent pixel More Information transparent pixel  
 £2.21 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Dimpled Knob Satin Chrome (33mm diameter)
Ref: 46063
  transparent pixel More Information transparent pixel  
 £2.89 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Dimpled Latch Satin Chrome (96mm centres)
Ref: 46019
  transparent pixel More Information transparent pixel  
 £3.76 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Dimpled Pull Handle Satin Chrome (47mm long)
Ref: 46014
  transparent pixel More Information transparent pixel  
 £2.23 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Dimpled Pull Handle Satin Chrome (53mm x 50mm)
Ref: 46059
  transparent pixel More Information transparent pixel  
 £2.80 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Dimpled Taper Bow Handle Satin Chrome (128mm centres)
Ref: 46067
  transparent pixel More Information transparent pixel  
 £2.21 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Dragon D Handle Satin Chrome (96mm centres)
Ref: 46088
  transparent pixel More Information transparent pixel  
 £3.13 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Epsilon Bow Brushed Chrome (192mm centres)
Ref: 45919
  transparent pixel More Information transparent pixel  
 £7.07 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Finger Pull Handle Matt Chrome (32mm centres)
Ref: 37762
  transparent pixel More Information transparent pixel  
 £3.28 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Gecko D Handle Satin Chrome (160mm centres)
Ref: 45989
  transparent pixel More Information transparent pixel  
 £7.97 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Hill Bow Handle Satin Chrome (128mm centres)
Ref: 46158
  transparent pixel More Information transparent pixel  
 £2.54 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Hill Bow Handle Satin Chrome (96mm centres)
Ref: 46152
  transparent pixel More Information transparent pixel  
 £2.54 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Hooked D Handle Matt Chrome (160mm centres)
Ref: 45579
  transparent pixel More Information transparent pixel  
 £5.52 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Hooked D Handle Satin Chrome (224mm centres)
Ref: 45544
  transparent pixel More Information transparent pixel  
 £7.54 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Knob Matt Chrome(16mm centres)
Ref: 37750
  transparent pixel More Information transparent pixel  
 £1.84 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Mini T Bar Handle Matt Satin Chrome (64mm centres)
Ref: 37766
  transparent pixel More Information transparent pixel  
 £2.20 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Oval Knob Chrome (50mm wide)
Ref: 45961
  transparent pixel More Information transparent pixel  
 £3.53 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Oval Knob Satin Chrome (30mm length)
Ref: 45994
  transparent pixel More Information transparent pixel  
 £2.54 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Oval Knob | 60mm | Matt Chrome ** DISCONTINUED 1 IN STOCK **
Ref: 37764
  transparent pixel More Information transparent pixel  
 £3.30 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Plain D Handle Matt Chrome (128mm centres)
Ref: 37755
  transparent pixel More Information transparent pixel  
 £1.60 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Plain D Handle Matt Chrome (160mm centres)
Ref: 37756
  transparent pixel More Information transparent pixel  
 £2.07 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Plain D Handle Matt Chrome (256mm centres)
Ref: 37758
  transparent pixel More Information transparent pixel  
 £2.75 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Plain D Handle Matt Chrome (96mm centres)
Ref: 37754
  transparent pixel More Information transparent pixel  
 £1.41 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Pointed Bow Handle Satin Chrome (128mm centres)
Ref: 46134
  transparent pixel More Information transparent pixel  
 £3.78 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Quatro D Handle Satin Chrome (160mm centres)
Ref: 46049
  transparent pixel More Information transparent pixel  
 £4.47 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Quattro D Handle Satin Chrome (128mm centres)
Ref: 46046
  transparent pixel More Information transparent pixel  
 £3.28 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Quattro D Handle Satin Chrome (96mm centres)
Ref: 46043
  transparent pixel More Information transparent pixel  
 £2.54 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Rainbow Bow Handle Satin Chrome (128mm centres)
Ref: 45969
  transparent pixel More Information transparent pixel  
 £4.62 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Rainbow Bow Handle Satin Chrome (96mm centres)
Ref: 45956
  transparent pixel More Information transparent pixel  
 £3.64 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Rainbow D Handle Satin Chrome (160mm centres)
Ref: 45512
  transparent pixel More Information transparent pixel  
 £7.67 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Ribbed Bow Handle Satin Chrome (160mm centres)
Ref: 46051
  transparent pixel More Information transparent pixel  
 £7.07 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Ribbed Pull Handle Satin Chrome (85mm long)
Ref: 46053
  transparent pixel More Information transparent pixel  
 £2.86 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Roundel D Handle Satin Chrome (128mm centres)
Ref: 45985
  transparent pixel More Information transparent pixel  
 £5.57 inc VAT 
QTY: 
  transparent pixel transparent pixel  
S Bow Handle Satin Chrome (128mm centres)
Ref: 46078
  transparent pixel More Information transparent pixel  
 £2.87 inc VAT 
QTY: 
  transparent pixel transparent pixel  
S Bow Handle Satin Chrome (96mm centres)
Ref: 45958
  transparent pixel More Information transparent pixel  
 £2.87 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Scoop Handle Satin Chrome (160mm centres) to suit a routed door
Ref: 46165
  transparent pixel More Information transparent pixel  
 £6.69 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Scoop Handle Satin Chrome (96mm centres) to suit a routed door
Ref: 46163
  transparent pixel More Information transparent pixel  
 £3.24 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Shaped Cup Matt Satin Chrome (128mm centres)
Ref: 37768
  transparent pixel More Information transparent pixel  
 £2.88 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Shaped Cup Matt Satin Chrome (96mm centres)
Ref: 37767
  transparent pixel More Information transparent pixel  
 £2.67 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Shell Style Handle Brushed Satin Chrome (96mm centres)
Ref: 46174
  transparent pixel More Information transparent pixel  
 £2.39 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Slim Square D Handle Satin Chrome (160mm centres)
Ref: 46181
  transparent pixel More Information transparent pixel  
 £3.00 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Slim Square D Handle Satin Chrome (256mm centres)
Ref: 46182
  transparent pixel More Information transparent pixel  
 £3.84 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Spoon Bow Handle Brushed Satin Chrome (160mm centres)
Ref: 46192
  transparent pixel More Information transparent pixel  
 £6.12 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Spoon Bow Handle Satin Chrome (160mm centres)
Ref: 46198
  transparent pixel More Information transparent pixel  
 £6.12 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Spoon Bow Handle Satin Chrome (224mm centres)
Ref: 46196
  transparent pixel More Information transparent pixel  
 £15.37 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Spoon Bow Handle Satin Chrome (384mm centres)
Ref: 46194
  transparent pixel More Information transparent pixel  
 £29.62 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Square Knob Satin Chrome (33mm length)
Ref: 45998
  transparent pixel More Information transparent pixel  
 £2.39 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Square Punched Bow Handle Satin Chrome (128mm centres)
Ref: 46074
  transparent pixel More Information transparent pixel  
 £3.49 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Square Punched Pull Handle Satin Chrome (63mm length)
Ref: 46055
  transparent pixel More Information transparent pixel  
 £3.74 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Stepped D Handle Satin Chrome (128mm centres)
Ref: 45944
  transparent pixel More Information transparent pixel  
 £5.70 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Stepped D Handle Satin Chrome (160mm centres)
Ref: 45946
  transparent pixel More Information transparent pixel  
 £6.59 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Stepped Knob Satin Chrome (35mm diameter)
Ref: 46039
  transparent pixel More Information transparent pixel  
 £4.68 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Strap D Handle Satin Chrome (96mm centres)
Ref: 46085
  transparent pixel More Information transparent pixel  
 £2.42 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Strap Handle Satin Chrome (128mm centres)
Ref: 45997
  transparent pixel More Information transparent pixel  
 £3.76 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Taper Bow Handle Satin Chrome (128mm centres)
Ref: 46079
  transparent pixel More Information transparent pixel  
 £3.64 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Taper Bow Handle Satin Chrome (96mm centres)
Ref: 45966
  transparent pixel More Information transparent pixel  
 £3.01 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Tapered D Handle Satin Chrome (128mm centres)
Ref: 45990
  transparent pixel More Information transparent pixel  
 £8.84 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Titan Bow Handle Satin Chrome (128mm centres)
Ref: 45914
  transparent pixel More Information transparent pixel  
 £5.19 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Titan Bow Handle Satin Chrome (160mm centres)
Ref: 45916
  transparent pixel More Information transparent pixel  
 £5.84 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Titan Bow Handle Satin Chrome (224mm centres)
Ref: 45933
  transparent pixel More Information transparent pixel  
 £6.92 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Titan Shell Handle Satin Chrome (128mm centres)
Ref: 46172
  transparent pixel More Information transparent pixel  
 £5.85 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Titan Shell Handle Satin Chrome (96mm centres)
Ref: 46166
  transparent pixel More Information transparent pixel  
 £4.62 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Trafalgar Bow Handle Satin Chrome (128mm centres)
Ref: 45983
  transparent pixel More Information transparent pixel  
 £6.02 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Twist D Handle Satin Chrome (96mm centres)
Ref: 46140
  transparent pixel More Information transparent pixel  
 £2.87 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Twist D Handle Satin Chrome (128mm centres)
Ref: 46142
  transparent pixel More Information transparent pixel  
 £3.35 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Victorian Knob Satin Chrome 950mm diameter)
Ref: 37840
  transparent pixel More Information transparent pixel  
 £8.18 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Victorian Satin Chrome Knob | 25mm Diameter
Ref: 37892
  transparent pixel More Information transparent pixel  
 £4.23 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Victorian Satin Chrome Knob | 32mm Centre
Ref: 37837
  transparent pixel More Information transparent pixel  
 £4.56 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Victorian Satin Chrome Knob | 38mm Diameter
Ref: 37838
  transparent pixel More Information transparent pixel  
 £4.97 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Victorian Satin Chrome Knob | 42mm Diameter
Ref: 37839
  transparent pixel More Information transparent pixel  
 £6.50 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Waisted Bow Handle Matt Chrome EFF (plastic) (128mm centres)
Ref: 42432
  transparent pixel More Information transparent pixel  
 £4.11 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Waisted Bow Handle Matt Satin Chrome (128mm centres)
Ref: 37765
  transparent pixel More Information transparent pixel  
 £3.15 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Waisted Bow Handle Satin Chrome (244mm centres)
Ref: 37751
  transparent pixel More Information transparent pixel  
 £5.86 inc VAT 
QTY: 
  transparent pixel transparent pixel  
Wave Bow Handle Satin Chrome (96mm centres)
Ref: 46092
  transparent pixel More Information transparent pixel  
 £2.87 inc VAT 
QTY: 
  transparent pixel transparent pixel  
 
Recently+Viewed+Products
array(3) { [0]=> array(4) { ["file"]=> string(67) "/home/live/public_html/tradehandles/includes/functions/database.php" ["line"]=> int(44) ["function"]=> string(12) "tep_db_error" ["args"]=> array(3) { [0]=> &string(73) "SELECT categories_name FROM categories_description WHERE categories_id = " [1]=> &int(1064) [2]=> &string(146) "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1" } } [1]=> array(4) { ["file"]=> string(70) "/home/live/public_html/tradehandles/includes/boxes/recently_viewed.php" ["line"]=> int(74) ["function"]=> string(12) "tep_db_query" ["args"]=> array(1) { [0]=> &string(73) "SELECT categories_name FROM categories_description WHERE categories_id = " } } [2]=> array(4) { ["file"]=> string(45) "/home/live/public_html/tradehandles/index.php" ["line"]=> int(801) ["args"]=> array(1) { [0]=> string(70) "/home/live/public_html/tradehandles/includes/boxes/recently_viewed.php" } ["function"]=> string(7) "include" } } 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

SELECT categories_name FROM categories_description WHERE categories_id = 
index.php
[TEP STOP]

D Handle Antiqued Brass and Bone (128mm centres)
01. D Handle Antiqued Brass and Bone (128mm centres) 
Ref: 37896
Flower Design Knob Beige/Black Ceramic (50mm diameter)
02. Flower Design Knob Beige/Black Ceramic (50mm diameter) 
Ref: 42476
Plain Finish Knob Black (30mm diameter)
03. Plain Finish Knob Black (30mm diameter) 
Ref: 38469
Flower Design Black/Beige Pull Handle Ceramic (146mm long)
04. Flower Design Black/Beige Pull Handle Ceramic (146mm long) 
Ref: 42478