autonumber in database

[Anon]

hi ,
how do u compare the retrived autonumber and the autonumber in the database using sql statement?
i'm using access database, n tried ...id='$id'
the browser gav mi error: data type mismatch
is there anyway to solve the prob?
thanz

[Anon]

ALTER TABLE tablename MODIFY field format auto_increment [not null];

ALTER TABLE T_Table MODIFY ID INT(4) auto_increment NOT NULL;