[msfdisk]

Can some one look at my code here and tell me why I cant get the "refer" field to insert into the table when ALL the others are working?

$name = $_POST['Name'];

if(!@mssql_query("INSERT INTO a_UserDemographics (refer,UserId, FName, LName, MName, Password, Phone, AddressTypeCd, Addr1, Addr2, City, StateCd,ZipCode, CountryCd, Email, Fax,Mobile) VALUES ('$name','$userid','$fname','$lname','$mname','$password','$priphone','R', '$addr1', '$addr2', '$city', '$state', '$zip','$country','$email', '$fax','$cell')"));

<input name="Name" type="text" id="Name">

Is there a limit to insert using a single insert statement. I'm lost. I can get it to work on its own but not with other fields.....

UGH = I've been starring at this for 3 days trying to figure it out.

THX

[msfdisk]

Can some one look at my code here and tell me why I cant get the "refer" field to insert into the table when ALL the others are working?

$name = $_POST['Name'];

if(!@mssql_query("INSERT INTO a_UserDemographics (refer,UserId, FName, LName, MName, Password, Phone, AddressTypeCd, Addr1, Addr2, City, StateCd,ZipCode, CountryCd, Email, Fax,Mobile) VALUES ('$name','$userid','$fname','$lname','$mname','$password','$priphone','R', '$addr1', '$addr2', '$city', '$state', '$zip','$country','$email', '$fax','$cell')"));

<input name="Name" type="text" id="Name">

Is there a limit to insert using a single insert statement. I'm lost. I can get it to work on its own but not with other fields.....

UGH = I've been starring at this for 3 days trying to figure it out.

THX

[Chicon]

Like this :

if(!@mssql_query("INSERT INTO a_UserDemographics VALUES ('$name','$userid','$fname','$lname','$mname','$password','$priphone','R', '$addr1', '$addr2', '$city', '$state', '$zip','$country','$email', '$fax','$cell')"));

[MMJ]

I need to see more code. Also please put it in [php][/php] tags, it makes it much easier to see.

[Cookiegal]

I've merged both threads together. Please do not start more than one for the same issue.

[msfdisk]

Chicon -
What did you do?

[msfdisk]

Here is some code:

<?

include('includes/dbConnect.php');
include('includes/functions.php');

//get the current timestamp
function get_current_datestamp(){
$currdate = gmdate("Ymd");
$currday = substr($currdate,6,2);
$currmonth = substr($currdate,4,2);
$curryear = substr($currdate,0,4);
$currdate_stamp = ($curryear . "-" . $currmonth . "-" . $currday);

return $currdate_stamp;
}
if($_POST['Submit']=='Submit'){

$fname = $_POST['FName'];
$mname = $_POST['MName'];
$lname = $_POST['LName'];
$addr1 = $_POST['Addr1'];
$addr2 = $_POST['Addr2'];
$city = $_POST['City'];
$state = $_POST['provState'];
$zip = $_POST['Zip'];
$country = $_POST['Country'];
$priphone = $_POST['PriPhone'];
$cell = $_POST['Cell'];
$fax = $_POST['Fax'];
$email = $_POST['EMail'];
$name = $_POST['Name'];

$code = $_POST['code'];
$dob = $_POST['dob'];
$password = $_POST['Zip'];
$sex = $_POST['Sex'];

//$datestamp = $currdate_stamp;

$trimmed_fname = trim($fname);//trim
$fname = strtolower($trimmed_fname);//convert to lower case
$fname_initial = substr($fname, 0,1);
$trimmed_lname = trim($lname);//trim
$lname = strtolower($trimmed_lname);//convert to lower case
$lname_initial = substr($lname, 0,1);
$trimmed_priphone = trim($priphone);//trim
$areacode = substr($trimmed_priphone, 0,3);//get the area code
$phone_7 = substr($trimmed_priphone, 3,7);//get the rest of the phone number
$userid = ''.$areacode.''.$fname_initial.''.$lname_initial.''.$phone_7.'';


$rs2 = @mssql_query("select * from a_UserDemographics where UserId='" . $userid . "'");
if(mssql_num_rows($rs2)){
$AddMsg = "This UserId Already exists!";
}else{
if(!@mssql_query("INSERT INTO a_UserDemographics (refer,UserId, FName, LName, MName, Password, Phone, AddressTypeCd, Addr1, Addr2, City, StateCd,ZipCode, CountryCd, Email, Fax,Mobile) VALUES ('$name','$userid','$fname','$lname','$mname','$password','$priphone','R', '$addr1', '$addr2', '$city', '$state', '$zip','$country','$email', '$fax','$cell')"));
$AddMsg = "The record has been added";
}



}//end submit

?>

[msfdisk]

bump - need immediate help please

[Winona-Forever]

In the past, when I deal in lengthy, in-line SQL inserts, half the time they'll have some unknown problem which can be difficult to see to the naked eye. The best way of solving the issue is to just print or echo the suspect variables, or the entire SQL string...

For example...

PHP Code:

echo("INSERT INTO a_UserDemographics (refer,UserId, FName, LName, MName, Password, Phone, AddressTypeCd, Addr1, Addr2, City, StateCd,ZipCode, CountryCd, Email, Fax,Mobile) VALUES ('$name','$userid','$fname','$lname','$mname','$password','$priphone','R', '$addr1', '$addr2', '$city', '$state', '$zip','$country','$email', '$fax','$cell')"); 


...put that line in somewhere near the mssql_query statement, then have a look through what it prints.