Perl submission possible?

[Colin-FON]

Hi everyone. I'm new to vB but loving the ability to modify everything through the SQL database. I am running a directory hosting program called AllManage on my website, which is written in Perl and also stores its data in the MySQL database. There was no overlap in table names, so I was able to use the same database to store all the info for both these programs. Now, my goal here is to create the AllManage account and vB account at the same time when a user submits their data to the AllManage registration form. I need a little help converting the vB info to perl if this is possible...I'm sure it is, I just don' t know how. The code I am using right now is this: (it's in the perl file mind you)

$sql3 = "insert into $user_table values (".
"'NULL','$username',password('$pw'),'$email',".
"'&username')";

Now this works...the syntax is correct, but I get the error message "Column count doesn't match value count"

Now obviously that is because I haven't entered enough fields to import into the "user" table of the vB database. Does anyone know how many fields I have to account for, or could anyone perhaps modify the code I have if you already know which order the information needs to be listed in?

Thanks for any help you can provide!

Colin Poole

[Wayne Luke]

Go into your MySQL command line and type "DESC user" and it will tell you all the different fields and which are not nullable. All the not nullable fields need a correct value when you insert a record.