cannot execute query

[chaps]

Can anyone help?

I have added a vat checker to a form script that worked fine befor. Can anyone see why I now get a Cannot execute query 104?

case "new":
foreach($HTTP_POST_VARS as $key => $value)
{
if ($key!= "fax")
{
if ($value == "")
{
unset($do);
$message_new = "Required information is missing. Please try again.";
include("login_form.inc");
exit();
}
}
if (ereg("{Name}",$key))
{
if (!ereg("^[A-Za-z' -]{1,50}$",$key))
{
unset($do);
$message_new = "$lastName is not a valid name. Please try again.";
include("login_form.inc");
exit();
}
}
$key = strip_tags(trim($value));
}
if (!ereg("^.+@.+\\..+$",$email))
{
unset($do);
$message_new = "$email is not a valid email address. Please try again.";
include("login_form.inc");
exit();
}

/* check vat number */
$vat1=$a*8 + $b*7 + $c*6 + $d*5 + $e*4 + $f*3 + $g*2;
$vat2=($vat1 - 97);
$vat3= 0 - $h*10 - $j;
if ($vat2 > -9)
{
$vat2=$vat2 - 97;
if ($vat2 > -9)
{
$vat2=$vat2 - 194;
}
elseif ($vat2!= $vat3)
{
unset($do);
$message_new = "VAT Number not valid";
include("login_form.inc");
exit();
}
else
{
$VAT_No = $a.$b.$c.$d.$e.$f.$g." ".$h.$j;
}
}

/* check to see if login name already exists */
$connection = mysql_connect($host,$user,$password)
or die ("Couldn't connect to server.");
$db = mysql_select_db(test,$connection)
or die ("Couldn't connect to database.");
$sql = "SELECT loginName FROM member
WHERE loginName='$newname'";
$result = mysql_query($sql)
or die ("Couldn't execute query 104.");
$num = mysql_numrows($result);
if ($num > 0)
{
unset($do);
$message_new = "$newname already used. Select another username.";
include("login_form.inc");
exit();
}

else
{

$today = time("Y-m-d");
$sql = "INSERT INTO member (loginName,createDate,password,firstName,lastName,company,address1,address2,
town,county,postcode,email,phone,fax,VAT_no) VALUES
('$newname','$today','$newpass','$firstName','$lastName','$company','$address1','$address2',
'$town','$county','$postcode','$email','$phone','$fax','$VAT_no')";
mysql_query($sql) or die(mysql_error());
$xsql = "INSERT INTO vat (LoginName,a,b,c,d,e,f,g,h,j,VAT_no) VALUES
('$newname','$a','$b','$c','$d','$e','$f','$g','$h','$j','$VAT_no')";
mysql_query($xsql);
$auth="yes";
$logname = "$newname";
/* send email to new member */
$emess1="A new wholesalers account has been setup for you. ";
$emess2="Your new username and password are: ";
$emess3="\n\n\tUsername:$newname\n\tPassword:$newpass\n\n";
$emess4="We appreciate your interest in Sculptures of Africa ";
$emess5="If you have any questions or problems, please email ";
$emess6="[e-mail]";
$emess = $emess1.$emess2.$emess3.$emess4.$emess5.$emess6;
$ehead="From: [e-mail]\r\n";
$subject = "Your new Wholesalers Account from Sculptures of Africa";
$mailsend=mail("$email","$subject","$emess","$ehead");
header("Location: New_member.php");
}
break;
default:
include("login_form.inc");
}
?>

Thanks,

Chris

[rlkanter]

What is the mysql error?

echo mysql_error();

[Stormfx]

Just a question about a section of your code:

Here:

$emess1="A new wholesalers account has been setup for you. ";
$emess2="Your new username and password are: ";
$emess3="\n\n\tUsername:$newname\n\tPassword:$newpass\n\n";
$emess4="We appreciate your interest in Sculptures of Africa ";
$emess5="If you have any questions or problems, please email ";
$emess6="[e-mail]";
$emess = $emess1.$emess2.$emess3.$emess4.$emess5.$emess6;

Why note write this like:

$emess="A new wholesalers account has been setup for you. ";
$emess.="Your new username and password are: ";
$emess.="\n\n\tUsername:$newname\n\tPassword:$newpass\n\n";
$emess.="We appreciate your interest in Sculptures of Africa ";
$emess.="If you have any questions or problems, please email ";
$emess.="[e-mail]";

using the .= operator? :)

[rlkanter]

or you could just do :P :

$emess="A new wholesalers account has been setup for you. "
."Your new username and password are: "
."\n\n\tUsername:$newname\n\tPassword:$newpass\n\n"
."We appreciate your interest in Sculptures of Africa "
."If you have any questions or problems, please email "
."[e-mail]";

[Stormfx]

Heh...