[DennisFaucher]

Fixed it. Yay.

$pandl = $_POST[“pl”];
$manuf_var = $_POST[“oem”];

$sql_var=”select ext_rev as x, discount as y, customer as z, manuf as w from innovation.ne_nj_tbl where pnl like ‘$pandl%’ and manuf like ‘$manuf_var%'”;

$handle = $link->prepare($sql_var);

[DennisFaucher]

@shashiranjan, thank you.

The data fields are not important, it is passing web form variables to the SQL statement that I need help with.

The PHP web form I am using is here: https://www.dropbox.com/s/7w2d7gy6nxaolex/inn_scatter_disc_entry.php?dl=0
The CanvasJS PHP with the SQL statement is here: https://www.dropbox.com/s/t1vhw82rfl947nr/inn_scatter_disc.php?dl=0

Here is an example of working PHP passing a web form to a SQL statement:

PHP web form: https://www.dropbox.com/s/et2p8nvft9e38y9/detail_entry.php?dl=0
Tabular result based on SQL: https://www.dropbox.com/s/r87ecj679ctejq4/detail_mysql.php?dl=0

Thank you.