Posts by The Diamonds

Hi,

You need to get the parameters for post params before you can use them in your email template.
Suppose that you have {name, email, order, subtotal, promo, tax, shipping, total} fields in your form, you need to write code like below before making MAIL call :

my $query = new CGI;

my $name = $query->param('name');
my $email = $query->param('email');
my $order = $query->param('order');
my $subtotal = $query->param('subtotal');
my $promo = $query->param('promo');
my $tax = $query->param('tax');
my $shipping = $query->param('shipping');
my $total = $query->param('total');

Yes, you're right that is another problem.. I didn't notice.

The SQL function count doesn't take two column names. try to use one column name or 1 or * as an argument for the function like this:

$q = 'SELECT COUNT(state) AS c FROM all WHERE state = "' . mysql_real_escape_string($nc) . '" AND title = "' . mysql_real_escape_string($t) . '"';

Are you supressing the error messages? The interpreter should be giving you the message & line number of the error by default.

Hi,

You have a problem at line 8; there is the = operator that shouldn't be. Just remove it and it will be fine.