Hello,
I am passing variables to my CanvasJS chart PHP from a web form
This SQL works
$handle = $link->prepare(‘select ext_rev as x, discount as y from mysql.ne_nj_tbl where pnl like \’Commercial NE Majors%\’ and manuf like \’CISCO%\”);
This SQL fails
$handle = $link->prepare(‘select ext_rev as x, discount as y from mysql.ne_nj_tbl where pnl like \’$pandl%\’ and manuf like \’$manuf_var%\”);
I have used that SQL successfully in another PHP script but not with CanvasJS. Any ideas? TIA.