T_constant_encapsed_string

Parse error in line 17

[gracecodesign]

Help! Great script

<?
include("header.txt");

include("my_const.h");

//connect to database
$con = mysql_connect(localhost,$g_dbuid,$g_dbpwd);

if ($con==NULL)
{
echo("301 Couldn't connect to MySQLnn");
exit(-1);
}

$db = mysql_select_db($g_databasename,$con);

$t="insert into users (companyname, contactname, email, baddress1, baddress2, bcity, bstate, bzip, saddress1, saddress2, scity, sstate, szip, tel, fax, active, bcountry, scountry, needsvalidation) values ("%s","%s","%s","%s","%s","%s","%s","%s","%s","%s","%s","%s","%s","%s","%s","0","%s","%s","1")";
$sql=sprintf($t, mysql_escape_string($companyname), mysql_escape_string($contactname), mysql_escape_string($email), mysql_escape_string($baddress1), mysql_escape_string($baddress2), mysql_escape_string($bcity), mysql_escape_string($bstate), mysql_escape_string($bzip), mysql_escape_string($saddress1), mysql_escape_string($saddress2), mysql_escape_string($scity), mysql_escape_string($sstate), mysql_escape_string($szip), mysql_escape_string($tel), mysql_escape_string($fax), mysql_escape_string($bcountry), mysql_escape_string($scountry));

[Timotheos]

Hi Gracecodesign and welcome to WebmasterWorld!

I take it this is line 17:

$t="insert into users (companyname, contactname, email, baddress1, baddress2, bcity, bstate, bzip, saddress1, saddress2, scity, sstate, szip, tel, fax, active, bcountry, scountry, needsvalidation) values ("%s","%s","%s","%s","%s","%s","%s","%s","%s","%s","%s","%s","%s","%s","%s","0","%s","%s","1")";

I think if you put single quotes [ca.php.net] around the string then it will work better.

$t='insert into users (companyname, contactname, email, baddress1, baddress2, bcity, bstate, bzip, saddress1, saddress2, scity, sstate, szip, tel, fax, active, bcountry, scountry, needsvalidation) values ("%s","%s","%s","%s","%s","%s","%s","%s","%s","%s","%s","%s","%s","%s","%s","0","%s","%s","1")';

All those double quotes in there is throwing the parser off