asked on

mysql php error: 1064

ok say so this happens to me everytime i modify php script. last time it was a bracket missing. ive checked that this time. someone fill me in why and what the best practice is.

here is my code:

<?php
if(strtolower($_POST["email"]) != strtolower( $_POST["emailconfirm"])) {

print "Error: Email addresses do not match";

}else{
$hostname=stuffhere;
$username=stuffhere;
$password=stuffhere;
$db=stuffhere;

$mysql = mysql_connect($hostname,$username,$password);
mysql_select_db($db);

if (mysql_errno()){
      printf("Connect failed: %s\n", mysql_errno());
      exit();
}else{

$inName = mysql_real_escape_string($_POST['name']);
$inCompany = mysql_real_escape_string($_POST['company']);
$inCity = mysql_real_escape_string($_POST['city']);
$inEmail = mysql_real_escape_string($_POST['email']);
$inZipcode = mysql_real_escape_string($_POST['zipcode']);
$inArecodephone = mysql_real_escape_string($_POST['areacodephone']);
$inPhone = mysql_real_escape_string($_POST['phone']);
$inAreacodefax = mysql_real_escape_string($_POST['areacodefax']);
$inFax = mysql_real_escape_string($_POST['fax']);
$inTrade1 = mysql_real_escape_string($_POST['trade1']);
$inTrade2 = mysql_real_escape_string($_POST['trade2']);
$inTrade3 = mysql_real_escape_string($_POST['trade3']);
$inTrade4 = mysql_real_escape_string($_POST['trade4']);
$inTrade5 = mysql_real_escape_string($_POST['trade5']);
$inTrade6 = mysql_real_escape_string($_POST['trade6']);
$inAL = mysql_real_escape_string($_POST['AL']);
$inDE = mysql_real_escape_string($_POST['DE']);
$inFL = mysql_real_escape_string($_POST['FL']);
$inGA = mysql_real_escape_string($_POST['GA']);
$inKY = mysql_real_escape_string($_POST['KY']);
$inMD = mysql_real_escape_string($_POST['MD']);
$inMS = mysql_real_escape_string($_POST['MS']);
$inNC = mysql_real_escape_string($_POST['NC']);
$inSC = mysql_real_escape_string($_POST['SC']);
$inTN = mysql_real_escape_string($_POST['TN']);
$inVA = mysql_real_escape_string($_POST['VA']);
$inDC = mysql_real_escape_string($_POST['DC']);
$inAddress = mysql_escape_string($_POST['address']);

$sql = "INSERT INTO subcontractors (name,company,city,email,zipcode,areacodephone,phone,areacodefax,fax,trade1,trade2,trade3,trade4,trade5,trade6,AL,DE,FL,GA,KY,MD,MS,NC,SC,TN,VA,DC,address) VALUES
('$inName','$inCompany','$inCity','$inEmail','$inZipcode','$inAreacodephone',$inPhone','$inAreacodefax',$inFax','$inTrade1','$inTrade2','$inTrade3','$inTrade4','$inTrade5','$inTrade6','$inAL','$inDE','$inFL','$inGA','$inKY','$inMD','$inMS','$inNC','$inSC','$inTN','$inVA','$inDC',$inAddress')";

if (mysql_query($sql,$mysql)) {
            $link="<a href=\"http://www.hale-building.com/subcontractors.html\">Return</a>";
echo('<table width="100%"><tr><td align="center">Return</td></tr></table>');
} else
printf("There was an error in the registration: %s\n", mysql_errno($mysql));
}

mysql_close($mysql);
}

?>

here is my error: 1064

ASKER CERTIFIED SOLUTION

steelseth12

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

hernst42

There is missing a ' infront of
$inFax'

steelseth12

a better way to do it would be

$sql = sprintf("INSERT INTO subcontractors (name,company,city,email,zipcode,areacodephone,phone,areacodefax,fax,trade1,trade2,trade3,trade4,trade5,trade6,AL,DE,FL,GA,KY,MD,MS,NC,SC,TN,VA,DC,address) VALUES
('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')",
            mysql_real_escape_string($inName),
            mysql_real_escape_string($inCompany),
            mysql_real_escape_string($inCity),
            mysql_real_escape_string($inEmail),
            mysql_real_escape_string($inZipcode),
            mysql_real_escape_string($inAreacodephone),
            mysql_real_escape_string($inPhone),
            mysql_real_escape_string($inAreacodefax),
            mysql_real_escape_string($inFax),
            mysql_real_escape_string($inTrade1),
            mysql_real_escape_string($inTrade2),
            mysql_real_escape_string($inTrade3),
            mysql_real_escape_string($inTrade4),
            mysql_real_escape_string($inTrade5),
            mysql_real_escape_string($inTrade6),
            mysql_real_escape_string($inAL),
            mysql_real_escape_string($inDE),
            mysql_real_escape_string($inFL),
            mysql_real_escape_string($inGA),
            mysql_real_escape_string($inKY),
            mysql_real_escape_string($inMD),
            mysql_real_escape_string($inMS),
            mysql_real_escape_string($inNC),
            mysql_real_escape_string($inSC),
            mysql_real_escape_string($inTN),
            mysql_real_escape_string($inVA),
            mysql_real_escape_string($inDC),
            mysql_real_escape_string($inAddress)

            );

Also have a look at http://www.php.net/manual/en/function.sprintf.php for more information on the sprintf() function.

bcmeyer1983

ASKER

i put the ' and still have the same error

bcmeyer1983

ASKER

got it left it off in more than one place

glcummins

Is there a reason you need to use mysql_errno()? If you use 'mysql_error()' instead, you will receive a full error message, instead of just a number.