mysql - PHP echo wrong value -

Hello I will call echo on product name from the product table Instead, instead of echo named class table , is there a way to isolate it from one of the 2 tables? Table: Product Paid Name 1 man 2 female 3 children Table: Category CatID name Pid 1 pen 1 2 pen 1 3 pencil 2 3 red_pen 3 table: active_product AIPID size pid price 1 12 1 10 2 14 2 15 3 16 3 20 4 18 4 30 PDO:

  $ stmt = $ conn- & gt; ("SELECT Product.Name" category, product, product, category WHERE product by pricing. ProdID = '$ item_id' and size = '$ size' and category .name = '$ pcategory' range1 " ); $ Stmt- & gt; BindParam ('$ ITEM_ID', $ ITEM_ID); $ Stmt- & gt; BindParam ('$ size', $ size); $ Stmt- & gt; BindParam ('$ pcategory', $ pcategory); $ Stmt- & gt; Executed (); Forex Currency ($ stmt-> Fatch ALL (PDO :: FETCH_ASSOC) as the $ line) {$ product_name = $ line ["name"];    
 
 
 Try it out:  
  SELECT Product.Name As PName, Category.As, Name, Size, Active_product, Product, Category WHERE Product.pid = 1 and Size = 10 and Name. Category = "Pen" range 1   
 Then in your PHP, do this:  
  $ product_name = $ row ["PName"];   
 Then your final product should be:  
  $ stmt = $ conn- & gt; ProdID = '$ item_id' and size = '$ size' and range. Name = '$ pcategory' ("SELECT Product.Name as PName, Category.Name AS Cnmem, size, product by product, category WHERE activation. Boundary 1 "); ... foreign currency ($ stmt-> fetchAll (PDO :: FETCH_ASSOC) as the $ line) {$ product_name = $ row ["PName"];