Jason Pruim wrote:
On Sep 12, 2008, at 8:53 AM, Nathan Rixham wrote:
Jason Pruim wrote:
nothing obvious to me.. so debug more!
<?PHP
function notify_email($Record, $salesRepID) {
echo "in notify_email" . PHP_EOL;
require("defaults.php");
echo "already loaded and required defaults loaded" . PHP_EOL;
require("func.sendemail.php");
echo "require func.sendemail.php loaded" . PHP_EOL;
require("dbmysqliconnect.php");
echo "already loaded and required dbmysqliconnect loaded" . PHP_EOL;
will tell you where it's breaking I'd assume..
Okay, when I had that in the notify_email.php file it looked like it all
loaded just fine... the echo's were displayed.
When I put that in my process.php file I got this output:
already loaded and required defaults loaded Just before send_email
functionjust after send_email funtion
require func.sendemail.php loaded
already loaded and required dbmysqliconnect loaded
execute error Duplicate entry '0' for key 1
So I think Jochem might be right... Problem with mysqli?
--
Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
11287 James St
Holland, MI 49424
www.raoset.com
japruim@xxxxxxxxxx
actually on closer inspection the problem looks here..
following requires 16 params:
mysqli_stmt_prepare($stmt, "UPDATE purl.schreur SET
FName = ?,
LName = ?,
email = ?,
phone = ?,
record = ?,
subscribed = ?,
date = ?,
IPAddress = ?,
Business = ?,
Address1 = ?,
City = ?,
State = ?,
Zip = ?,
Coffee = ?,
Meeting = ?,
time = ?")
or die("prepare error " . mysqli_error($link));
17 params bound AND rdoTime + areaPlans are in wrong order or are just
wrong..
mysqli_stmt_bind_param($stmt, 'ssssssssssssssss',
$_POST['txtFName'],
$_POST['txtLName'],
$_POST['txtEmail'],
$_POST['txtPhone'],
$_POST['record'],
$_POST['subscribed'],
$date,
$_SERVER['REMOTE_ADDR'],
$_POST['txtBusiness'],
$_POST['txtAddress1'],
$_POST['txtCity'],
$_POST['txtState'],
$_POST['txtZip'],
$_POST['rdoCoffee'],
$_POST['rdoTime'],
$_POST['areaPlans'])
or die( "bind error " . mysqli_error($link));
may help; probable causing the duplciate error problem; (doesn't explain
first error though)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
