I have a database with a perl query script.
I have an HTML file which contains the following.
<!--#exec cgi="cgi-bin/prices.pl?code=000003" -->
the perl scrip looks like this.
#! c:/perl -w
$code=$input->param('code'); #product code
$dbh=DBI->connect('DBI:mysql:furniture') || die 'ERR: connect';
$query="SELECT price FROM benches WHERE code=?";
print "$code <--";
the database has stock codes and also has prices linked to the stock
codes. Im trying to get it to print the price from knowing the stock
code... can anyone tell me what could be wrong with the perl script ?
It was working in offline mode - IF I entered 000003 as the stock code -
it returned the correct price. But when running it thru the HTML page
with the #exec it returned "0 rows"
Help would be much appreciated. Thanks :)