Update Client Record and Insert New Records

[Sponge Bob]

Thanks litewarez.

Ok i have made the database.

But as you are saying i should have another column in my members list for the ptype_id well.

A client should be able to call any number with either 0800 or 0845 prefix.

I also added the login system Mr.Happy has told therefore i have the php-login-script.com now.

Also litewarez, sorry i didnt get this part:

you can then add a column in your users table and depending on the type of call you putt an id in the ptype column for users..

this way each user will have the id number to a row in the other table

then what you can do is use JOINS to get the type of call with the user

Code:
SELECT *.user FROM users LEFT JOIN ptypes ON (users.ptype_id = ptypes.ptype_id) WHERE user_id = 2;
then you can always change the prices and it will propagate throughout the application.

Is it possible by any chance i can give u the details of my host if you can alter for me abit.

Thanks for your time and help.

Regards

[litewarez]

yea of-coarse dood, but it wont be till little later on. im out now

[dermechove]

Actually his post makes feel that he know what he's doing.

1. I want to design a system whereby a person can register and the details get logged into MYSQL. ( I have done this )
2. The person can login and go to the members area, the username and password should be correct from the mysql ( Done this )

When I posted that code up in there I didn't know that he will use it as it is.Else I would at least say that it's vulnerable.

[Sponge Bob]

Hello,

You can see how far i have gone with the registration part you can see this

www.callsforu.com/beta/login.php

well basically added a template.

Thanks & Regards

[Sponge Bob]

Anyone please assist.

Thanks