Custom Registeration
 

Hi folks,

I am currently setting up a website for online learning. It has two databases - one for students (name, email grades etc.) and the other for VB.

The board can only be viewed in the student Area which is password protected.

Anyway in order to enter the student area, an admin has to set up an account for you, which is done using a simple form which is sent to the Student DB. I then use the data from that form to also set up a VB account. Anyway to cut a long story short here is my problem:

The new VB account is created fine and the newest user is the last student created, which is correct. However when I log into the Admin section of VB and click on list all users these names do not appear??

when creating the VB account I am only adding the data to the USER tabe. (see code below)

$result = mysql_db_query("bulletin_board", "INSERT INTO user (userid,username,password,email,styleid,parentemai l,coppauser,homepage,icq,aim,y ahoo,signature,adminemail,showemail,invisible,user title,joindate,cookieuser,days prune,lastvisit,lastactivity,usergroupid,timezoneo ffset,emailnotification,receiv epm,emailonpm,options,birthday) VALUES (NULL,'2','$username','".addslashes(md5($Password) )."','$Email','0','','0','http ://www.','','','','$fname $sname','1','1','0','','0','".time()."','1','-1','".time()."','".time()."','".time()."','0','0', '1','1','0','','0','15','0000-00-00')");

Can someone help? Hope you understand my problem.
:ermm:

Why did that post not fit into the screen?
Sorry if it was me

There was no break in the (userid,username....) line. Don't worry. We are used to it. :)