Lookup

[Anon]

How can you use lookup on the Form which will query the database and allow you to select one item?

How can I verify the email entered has not already been entered in the database?

Thanks

[Anon]

How can I verify the email entered has not already been entered in the database?

do a SQL query like this:

$result = mysql_query("SELECT email FROM table WHERE email LIKE $email");
if(mysql_rows_affected($result) != 0) {
// email ALREADY in database
} else {
// whatever you want =)
}

Hope this help...

inKel