The choice is {$myValue} "; $sql = "Select * from product where NAME = '{$myValue}'"; $result = mysql_query($sql); while ($row = mysql_fetch_assoc($result)) $price = $row['PRICE']; $id = $row["ID"]; echo "PHP $price" $sql2 =" INSERT INTO `starbucks`.`order_details` (`ID`, `ORDER_ID`, `PRODUCT_ID`, `QTY`) VALUES ('2', '1', '$id', '1'); " $result2 = mysql_query($sql2); ?> echo "PHP $price" $sql2 =" INSERT INTO `starbucks`.`order_details` (`ID`, `ORDER_ID`, `PRODUCT_ID`, `QTY`) VALUES ('2', '1', '$id', '1'); " echo "PHP $price"; $sql2 =" INSERT INTO `starbucks`.`order_details` (`ID`, `ORDER_ID`, `PRODUCT_ID`, `QTY`) VALUES ('2', '1', '$id', '1'); ";