MySQL Forums
Forum List  »  PHP

Re: PHP SQL Registration Help
Posted by: Roland Bouman
Date: July 26, 2005 04:40AM

When you use the INSERT syntAx like this (that is, without explicitly naming the target columns) you must be sure that the value list matches the table column list exactly.
So, it seems, your table auth has either more or less than two columns.

It;s best to always use INSERT syntax including the target column list:

insert
into sometable (
targetcolumn1
, targetcolumn2
...
)
values (
val1
, val2
)

good luck.

Options: ReplyQuote


Subject
Written By
Posted
July 25, 2005 05:59PM
Re: PHP SQL Registration Help
July 26, 2005 04:40AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.