AddNew User Into........

[Logitech-2004]

I Build A Nifty Little Shoping Cart, And It Has It's Own Member Management System, But I Wanted To Add A Small Code To Add The User Into The VB3 Database, But My SQL Query Must Be Wrong.... Or Something. Worked Great In Vb2.3.3.

	$query="INSERT INTO user (usergroupid,username,password,passworddate,email,styleid,usertitle,salt,daysprune,reputation,pmpopup,startofweek,pmtotal,pmunread,threadedmode,autosubscribe,maxpost,referrerid,birthday_search,option,autosubscribe) VALUES ('$usergroupid','$username','$saltedpassword','$transactiondate','$email','0','$title','$salt','0','10','1','1','0','0','0','-1','-1','0','0000-00-00','6487','-1')";
	mysql_query($query);
	$userid=mysql_insert_id();
	$query="INSERT INTO userfield SET userid='$userid'";
	mysql_query($query);
	mysql_close();

Any Ideas?