Adding record and updating Access 2000 Database

[ph8edsicness]

I'm running a small access 2000 database on server 2000 to store member info: username, password and email. What I need to know is how to query the database to add a record when a new user registers and update the database auto-incremently. What's the correct way to do this?

[barand]

You need to connect via ODBC and use php's ODBC functions

Define member id field as 'autonumber'

To insert new record

$conn = odbc_connect ('host' , 'user' , 'pwd' );
$sql = "INSERT INTO member (username, password, email)
             VALUES ( '$username' , '$password' , '$email' ) ";
odbc_exec ($conn, $sql);

[ph8edsicness]

Thanks, hopefully it works.