yes, or you need to use the 'INSERT INTO ([field1, field2...]) values
(['val1', 'val2'...]) syntax. check the mysql insert syntax.
On Sat, Mar 15, 2003 at 06:37:54PM -0500, Louie Henry <[EMAIL PROTECTED]> wrote:
> Good Day All!
> I have been working a php/mysql and I have ran into a small problem. I
> have written an html form for inserting data, and it will not insert
> it. I am able to query the data from the data. I here is some of the code,
> maybe some one could point out the error.
> $query = "INSERT into TBLutnsUser values
> ( ".$fname.", ".$lname.", ".$email.", ".$phonenum.", ".$celnum.",
> ".$address.", ".$city.", ".$prov.", ".$postalcode.")";
> There is one other field that is not in here, that is userIndex. and it is
> the indexing/primary key, and it is auto_increment. dose it need to be
> added in here too?
> Thank You
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php