Jason Pruim wrote:
Okay... So I know this is a stupid question... But I've been staring at my code for far too long and now it's still not working so I thought I would show it to all of you and see if you can tell me where I'm being stupid :)

this is dbmysqliconnect.php:
<?php


function dbmysqliconnect($server, $username, $password, $database, $link) {
                $link = mysqli_init();
mysqli_real_connect($link, $server, $username, $password, $database) or die('could not connect: '.mysqli_connect_error());


                if (mysqli_connect_errno($link)) {
printf("Connect failed: %s\n", mysqli_connect_error($link));
                        exit();
                }

        return $link;
        }
?>

this is a snipet of my index.php file:

<?PHP
        include("php.ini.php");
        include("defaults.php");
        include("dbmysqliconnect.php");
        include("notify_email.php");
        include("send_email.php");

$link = dbmysqliconnect($server, $username, $password, $database, $link);




//Do NOT insert or update sales rep database through this method... Only included to be supplied to the notify_email function. JP
        $salesRepID = $_POST['salesRepID'];

        $stmt = mysqli_stmt_init($link);

        //Create the statement

        mysqli_stmt_prepare($stmt, "UPDATE database.table (
FName, LName, email, phone, url, record, subscribed, date, IPAddress, Business, Address1, City, State, Zip, Coffee, Meeting, areaPlans) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");

        // Error checking. JP

        echo "<BR>Print of post:<BR>";
        print_R($_POST);
        echo "<BR>dump of the statement:<BR>";
        var_dump($stmt);



        mysqli_stmt_bind_param($stmt, 'sssssssssssssssss',
$_POST['txtFName'], $_POST['txtLName'], _POST['txtEmail'], $_POST['txtPhone'], $_POST['txturl'], $_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(mysqli_error($link)); <--------LINE 67

        echo "<BR>Dump of stmt:<BR>";
        var_dump($stmt);
        //Add the record
        mysqli_stmt_execute($stmt) or die(mysqli_error($link));

        printf("Error: %d.\n", mysqli_stmt_error($stmt));
        printf("%d Row Inserted.\n", mysqli_stmt_affected_rows($stmt));
        $check = mysqli_stmt_error($stmt);
        echo "<BR>$checkdate<BR>";

        notify_email($Record, $salesRepID);

?>

The error that I am getting is:

Warning: mysqli_stmt_bind_param() [function.mysqli-stmt-bind-param]: invalid object or resource mysqli_stmt in /public_html/purl/purlprocess.php on line 67 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '( FName, LName, email, phone, url, recor' at line 1

Am I just going crazy or is there something really wrong?

Okay.. I'm done... First stupid question of the year... Only 3,349,587 more to go for the year! :P



--
Jason Pruim
japr...@raoset.com
616.399.2355





Maybe try enclosing your field names in backticks?

Jay

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to