Create User script - Password error

[Mike McAnulty]

Hi there,

This is my first post, even though I have been registered for a while. Hello to everyone on the forum. I hope someone can help me with this issue.

I am using the following code to generate a user in the member table of my database. When I get it to work, I want to be able to script the creation of multiple members (teachers) rather than have them do it individually.

CODE
---------------
INSERT INTO member (`username`,`email`,`password`) VALUES('dummyusername','[e-mail]',PASSWORD('password'))
---------------
END CODE

The code generates the user in the database ok, but the password field has a asterisk at the start. I am unable to log in to my application.

When I create a user through the normal register interface this doesn't happen.

Can anyone throw some light on this for me?

Many thanks in advance.

Mike