bagaimana memunculkan produk referensi pada combo box pilih produk?

ini code nya manteman. saya bingung ga nemu

Recomendation

User Referensi

Pilih Usernameprepare('SELECT * FROM users where username !=? '); $stmt->bindParam(1, $_SESSION["user"]["username"], PDO::PARAM_STR); $stmt->execute();

$idnya=$_GET["user"]["username"];

?> fetch(PDO::FETCH_ASSOC)): ?> >

Produk Referensi

Pilih Produkprepare(' SELECT DISTINCT(nama_product) FROM tblproduct JOIN tbluserrating T1 ON tblproduct.id = T1.id_product JOIN tbluserrating T2 ON tblproduct.id = T2.id_product WHERE T1.id_product=T2.id_product and T1.rating is not null and T2.rating is not null and T1.id_pelanggan=(select id from users where username=?) and T2.id_pelanggan=?'); $stmt->bindParam(1, $_SESSION["user"]["username"], PDO::PARAM_STR); $stmt->bindParam(2, $idnya, PDO::PARAM_INT);

$stmt->execute();

?> fetch(PDO::FETCH_ASSOC)): ?>