Select deleted a record and searching for others with the same code [closed]

Question

Navigation

#1 by (2 votes)

0

The product code I pass into the sql via php.

For example $ cd_product = 2; I would like to list everything but the record for this product (cd_product! = 2).

So far so good.

But I would just like the records of the table (product_table) with the category code for that product (2).

SELECT * 
FROM tabela_produto 
WHERE cd_produto != 2  AND cd_categoria = (como saber o código da categoria desse produto que foi eliminada)

php mysql select where

asked by anonymous 27.01.2017 / 17:24

1 answer

Bootstrap Button Disable button during javascript processing c #

score 2 · Accepted Answer

2

So:

SELECT * FROM tabela_produto WHERE cd_produto != 2 AND 
cd_categoria = (select cd_categoria from tabela_produto where cd_produto = 2 )

27.01.2017 / 17:33