Problem with Variables

[siefkencp]

I am having a problem with a form submit where some times variables are making it through and other times they are not. Can some one please help me figure out whats going on here? I have a sample of the code below

 

<?php
include '/mysql_connect.php';
include '/comment.html';
include '/newheader.php';

if($amount == '-1')
{
$amount = $amountother;
}


$date = time();
$dbdate = date("m/d/y G.i:s", $date);

mysql_query ("INSERT INTO donations (date, amount , howoften , cardtype , cardnumber , cardexpires , nameoncard , 
bankname , bankacct , bankacctname , name , class , address , city , state , zip , phone , email , matching , 
employer , bizaddress , bizphone , bizfax , infoestate , infostock , comments) 
VALUES ('$dbdate' , '$amount' , '$howoften' , '$cardtype' , '$cardnum' , '$cardexp' , '$nameoncard' , 
'$bankname' , '$bankacct' , '$bankacctname' , '$name' , '$class' , '$address' , '$city' , '$state' , 
'$zip' , '$phone' , '$email' , '$matching' , '$employer' , '$bizaddress' , '$bizphone' , '$bizfax' , 
'$moreinfo_estate' , '$moreinfo_stock' , '$comments')")
or die ("Unsuccessful"); 

$address = "[e-mail];[e-mail]";
$address_ary = explode(";", $address);
$headers = "From: Online Gift Form <[e-mail]> \n";
$headers .= "Content-type: text/html";
$msg = "This is a note that there is an online gift avalable. <br>";
$msg .= "Name: $name <br>";

$msg .= "Amount: $amount <br>
E-mail Address: $email <br>
<br>
<a href=\"www.blah.blah/blah\">Check the data base now?</a>";
foreach ($address_ary as $key => $value){
mail($address_ary[$key], $sub, $msg , $headers);
}

print "Success! We should send you a confirmation that the transaction has been completed with in the week.";

include '/newfooter.php';

//this include closes mysql
include '/close.php';
?> 

Sometimes the info comes through and others no...

Any help or thoughts would be apreciated!
Chris

[tekky]

sometimes it comes through in the email or on the submital page or where exactly?

[siefkencp]

Sometimes it dosen't come through at all. Its as though the variables never get data. The problem comes and goes half get real data and the other get no data. And submission never errors, it always goes to success.

[tekky]

Where does $address_ary come from?

[siefkencp]

The $address_ary is an array with all the people to recieve my e-mail... the e-mail is sent seperatly with the do while loop. This is for confidentiality purposes...

[tekky]

the mass mail() could be causing the mailserver to BLOCK some of the SMTP attempts.... your code doesnt look flawed, and you said it works most of the time... I would put my money on that.... you may need to break your list into smaller segments and process each one of those segments with a small delay between them...

[siefkencp]

There are only 3 reciepients and the data does not go into the database either. Any more ides?

[tekky]

$sql = "INSERT INTO donations (date, amount , howoften , cardtype , cardnumber , cardexpires , nameoncard , 
bankname , bankacct , bankacctname , name , class , address , city , state , zip , phone , email , matching , 
employer , bizaddress , bizphone , bizfax , infoestate , infostock , comments) 
VALUES ('$dbdate' , '$amount' , '$howoften' , '$cardtype' , '$cardnum' , '$cardexp' , '$nameoncard' , 
'$bankname' , '$bankacct' , '$bankacctname' , '$name' , '$class' , '$address' , '$city' , '$state' , 
'$zip' , '$phone' , '$email' , '$matching' , '$employer' , '$bizaddress' , '$bizphone' , '$bizfax' , 
'$moreinfo_estate' , '$moreinfo_stock' , '$comments')";

echo $sql . '<br>';
$result = mysql_query($sql) OR die('Error: ' . mysql_error());

try something like that.... (with $result) you can check mysql_affected_rows($result) and see if any insert took place....

[siefkencp]

The insert takes place, the problem is the variables which seem to contain no values. But not all of the time only intermitantly it seems PHP can't always capture the variables.