Hello,
create a table to hold all of your names and create a column for their status (lost or found) with the following schema.
create table classmates
(
id int not null primary key auto_increment,
name varchar(50) default "" not null,
status varchar(12) default "lost" not null,
created datetime,
updated datetime
)
insert all the classmates
insert into classmates (name,created) values ('name1',now());
insert into classmates (name,created) values ('name2',now());
...
insert into classmates (name,created) values ('nameN',now());
when someone signs up.
$query = sprintf("update classmates set status = 'found',updated = now where name='%s'",
mysql_real_escape_string($name_from_form_post)
);
mysql_query($query) or die("username:" . $name . " was not found" );
Cheers,
Joseph Melnick