Class reunion registration script

[alphamic]

This is my first time attempting to use MYSQL along with Dreamweaver CS3 to create a class reunion registration page.  I'm using a previous site's design but the PHP code for the registration is giving my problems and I have no idea how to correct it.   

 

Here is what I'm looking to do.  Take a look at this page: http://www.seaholm87.com/registration.htm.  This is what I need for the database.  Then take a look at this page (ignore the error): http://www.seaholm87.com/lost_found.php.  Once people register I'd like their name to be dropped from the 'People we are still looking for' list and then added to the 'People we have found' list with a link to their bio (as shown on the Lost and Found page linked above).  I have a list of new names which need to be placed in the 'People we are still looking for' list.  I just can't figure out how to get rid of those previous names which are still in the 'People we have found' list.

 

I'm trying to get the page up by this Monday (June 23rd) and I need to figure out what to do ASAP.  I have limited experience with MYSQL other than a short tutorial, and I only know the very basics of Dreamweaver CS3.  I thought this would be an easy site to make since I was given all the website files from www.seaholm87.com.  If anyone could point me to a script I could use, or how I can just replace the old names with the new class reunion people names I'd be delighted.  I'll send you whatever file you need to take a look at if necessary.

 

Please be nice lol.  I'm a 100% newb at this stuff and tutorials are not helping much at this point.

 

Thanks in advance

[hitman6003]

Ummm, www.reunion.com?

[jmelnick]

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