mysqli_stmt_bind_param question

Hi Everyone,

I have a MySQL database that I am accessing from PHP. The table in  
question has a auto increment field on it and I don't want to include  
that in my add/edit/update query's to the database... But I can't seem  
to figure out how to ignore it? Everything I have done seems to fail..  
I am using prepared statements so I"m not sure it that is it, but I  
would like to keep using them since it reduces the security issues a  
little... Here is the code from one of my prepared statements:

//Create the statement
mysqli_stmt_prepare($stmt, "INSERT INTO legionCurrent VALUES  
( ?,?,?,?,?,?,?,?)");
mysqli_stmt_bind_param($stmt, 'ssssssss', $FName, $LName, $Add1,  
$Add2, $City, $State, $Zip, $XCode)or die(mysqli_error($addlink));
//Add the record
mysqli_stmt_execute($stmt) or die(mysqli_error($addlink));

Here is the error I get in my logs:

[Fri Apr  4 09:35:32 2008] [error] PHP Warning:   
mysqli_stmt_bind_param() [<a href='function.mysqli-stmt-bind- 
param'>function.mysqli-stmt-bind-param</a>]: invalid object or  
resource mysqli_stmt\n in /Volumes/RAIDer/webserver/Documents/dev/ 
OLDBv2/add.php on line 91

Line 91 is the mysqli_stmt_bind_param() line above

My database structure looks like this:

| FName      | LName     | Add1    | Add2    | City | State | Zip  |  
XCode  | Reason  | Record

I know there is away to do it, but all my searching and reading hasn't  
told me anything... I've looked in the php manual, and mysql, plus  
various websites... and I just can't figure this one out... RTFM's are  
appreciated, as long as M is defined! :)

Thanks for taking the time to look!



--

Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
3251 132nd ave
Holland, MI, 49424-9337
www.raoset.com
[email protected]