Hi Krister,

On Apr 4, 2008, at 2:35 PM, Krister Karlström wrote:
Hi!

First of all you must connect to the server and then perform an init to get a statement. Maybe you dropped that code out here... Please have a look at the manual page:

http://www.php.net/manual/en/function.mysqli-stmt-prepare.php

In order to get the result you also need to bind the result to a variable and then fetch the data.

I'll guess that your error comes from an unsuccessful initialization of your prepared statement.

If you don't want to include your primary key column that is autogenerated you just ignore it. That means to write a proper query like:

INSERT INTO legioCurrent (column_1, column_2, ...)
VALUES (?,?,...)

I was not aware with prepared statements you could do it that way... Thank you! Once I added that it worked like a charm! Not quite sure how I missed that on the manuel page though...



I would also like to propose for you to use the object oriented style, since it's more readable and easier to get an overview of.

I have never been able to understand OO code... For me the procedural code is much easier to read.



You also don't need to mess around with so many parameters.

What do you mean by this?




--

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




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

Reply via email to