1. I read an article one day about using css in php forms to validate that the person filling out the form is actually a person, (typing in numbers seen on an image). Where's a link I can use the script for that, or learn how to do it?

2. What do I create a script that checks to see if an email address entered is already taken?



Thanks guys

1. You want a CAPTCHA, which doesn't exactly use CSS. You can find them at www.captcha.net and www.captchas.net

2. You will want to compare it against a database holding email address registered (I assume you mean to your site), using MySQL integrated into PHP.

Hope this helps,
Harry

Ok, got number 1, but how would I do number 2 though, coding wise.

To check if email already exists just do a basic query on the users table such as
'SELECT username FROM tbl_users WHERE username= $_POST['email_address'] '
Use the mysql_num_rows function to redirect to a login failed script. If there is a row returned then the email already exists.

$FoundUser = mysql_num_rows($result);

if($FoundUser){
header ("Location: loginFailed.php");
exit;
}

ok, thanks!

also one last question. I wanted to create a script that look for the number of unique email address (email) in a table (info). How would i do that

As for unique you can use DISTINCT in the query.

"SELECT DISTINCT email FROM info"

<?php


$username = "*";
$password = "*";
$hostname = "localhost";
$database = "*";


$dbh = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");

$selected = mysql_select_db($database,$dbh)
or die("Could not select");



$result = mysql_query("SELECT DISTINCT email FROM info");

echo $result
?>




like that?

don't want to be mean but read a tutorial before asking for basic knowledge
http://www.tizag.com/mysqlTutorial/mysqlquery.php